1. 系统权限
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'LCAM_SYS_1216'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');
系统权限
2.对象权限
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE = 'LCAM_SYS_1216'
UNION ALL
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');
对象权限