Oracle查出一个用户具有的所有系统权限和对象权限

1. 系统权限

1 SELECT *
2 FROM DBA_SYS_PRIVS
3 WHERE GRANTEE = 'LCAM_SYS_1216'
4 UNION ALL
5 SELECT *
6 FROM DBA_SYS_PRIVS
7 WHERE GRANTEE IN
8      (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');

 

2.对象权限

1 SELECT *
2 FROM DBA_TAB_PRIVS
3 WHERE GRANTEE = 'LCAM_SYS_1216'
4 UNION ALL
5 SELECT *
6 FROM DBA_TAB_PRIVS
7 WHERE GRANTEE IN
8      (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');