oracle常用sql语句

查看用户权限有哪些

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