【Oracle】权限相关

系统权限


SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
     (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = ' 用户名 ');




对象权限


SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE IN
     (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = ' 用户名');






查询角色权限
select * from dba_sys_privs where grantee='RESOURCE';