用户权限查看

原文连接：

 

LISTING INFORMATION ABOUT PRIVILEGES

 

To see which table privileges are granted by you to other users.

 

SELECT * FROM USER_TAB_PRIVS_MADE

 

To see which table privileges are granted to you by other users

 

SELECT * FROM USER_TAB_PRIVS_RECD;

 

To see which column level privileges are granted by you to other users.

 

SELECT * FROM USER_COL_PRIVS_MADE

 

To see which column level privileges are granted to you by other users

 

SELECT * FROM USER_COL_PRIVS_RECD;

 

To see which privileges are granted to roles

 

SELECT * FROM USER_ROLE_PRIVS;