查询Oracle 数据库用户权限的方法

select privilege, admin_option
from user_sys_privs
order by privilege;

select owner, table_name, privilege, grantable
from user_tab_privs_recd
order by owner, table_name, privilege;

select granted_role, admin_option, default_role
from user_role_privs
order by granted_role;

select distinct privilege
from (
    -- 直接授予的系统权限
    select privilege from user_sys_privs
    union all
    -- 角色携带的系统权限
    select rp.privilege
    from role_sys_privs rp
    where rp.role in (select granted_role from user_role_privs)
)
order by privilege;

select '系统权限' as 权限类型, privilege as 权限名称 from user_sys_privs
union all
select '所属角色' as 权限类型, granted_role as 权限名称 from user_role_privs
union all
select '对象权限' as 权限类型, owner||'.'||table_name||'('||privilege||')' as 权限名称 
from user_tab_privs_recd
order by 权限类型, 权限名称;