show all privileges from a user in oracle

SELECT * FROM USER_SYS_PRIVS; 
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;

SELECT * FROM USER_SYS_PRIVS; 
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;

 

posted @ 2019-10-17 17:48  kakaisgood  阅读(96)  评论(0编辑  收藏  举报