特权信息

授予用户的所有角色。

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)