1. 系统权限
SELECT *
FROM dba_sys_privs
WHERE grantee = 'SCOTT'
UNION ALL
SELECT *
FROM dba_sys_privs
WHERE grantee IN (SELECT granted_role
FROM dba_role_privs
WHERE grantee = 'SCOTT');
2. 对象权限
SELECT *
FROM dba_tab_privs
WHERE grantee = 'SCOTT'
UNION ALL
SELECT *
FROM dba_tab_privs
WHERE grantee IN (SELECT granted_role
FROM dba_role_privs
WHERE grantee = 'SCOTT');