You can try these below views.
SELECT * FROM USER_SYS_PRIVS;
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;
http://stackoverflow.com/questions/9811670/how-to-show-all-privileges-from-a-user-in-oracle
No comments:
Post a Comment