User Privilege of Oracle Database

-- 查询系统权限，角色
select grantee,privilege as privs_or_roles,admin_option from dba_sys_privs where grantee='JOVE'
union all
select grantee,granted_role,admin_option from dba_role_privs where grantee='JOVE';

-- 查询对象权限
select * from dba_tab_privs where grantee='JOVE';

-- 查询角色 / 角色权限
select * from dba_roles;
select * from role_sys_privs where role='DBA';
select * from role_tab_privs where role='DBA';

-- 数据库提供的系统权限 / 对象权限
select name from sys.system_privilege_map;
select * from table_privilege_map;