SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE = 'USERNAME'
UNION ALL
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'USERNAME');
用户系统权限:
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'USERNAME'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'USERNAME');