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. 对象权限
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. 对象权限