Oracle 权限

--权限

--登陆用户查询自己权限（会话）
select * from session_privs;

--查询用户所拥有系统权限
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'USERNAME'; 

--查询用户所拥有对象权限
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'USERNAME';

--查询用户所拥有的角色
SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'USERNAME';

--具体细化
--系统权限
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'HEXT'
UNION ALL
SELECT * FROM DBA_SYS_PRIVS
WHERE GRANTEE IN (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'HEXT');

--对象权限
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'HEXT'
UNION ALL
SELECT * FROM DBA_TAB_PRIVS
WHERE GRANTEE IN (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'HEXT');

--查看所有用户
select * from dba_user;
select * from all_users;
select * from user_users;
--查看用户系统权限