Wednesday, November 21, 2012

How to show all privileges from a user in oracle

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