特權資訊

授予使用者的所有角色。

select * 
from dba_role_privs 
where grantee= :username

授予使用者的許可權：

1. 系統許可權

select * 
from dba_sys_privs 
where grantee = :username

2. 物件補助金

select * 
from dba_tab_privs 
where grantee = :username

授予角色的許可權

授予其他角色的角色。

select * 
from role_role_privs 
where role in (select granted_role from dba_role_privs where grantee= :username)

1. 系統許可權

select * 
from role_sys_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)

2. 物件補助金

select * 
from role_tab_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)