Oracle Database Privilege information


Example

All roles granted to user.

select * 
from dba_role_privs 
where grantee= :username

Privileges granted to user:

  1. system privileges
select * 
from dba_sys_privs 
where grantee = :username
  1. object grants
select * 
from dba_tab_privs 
where grantee = :username

Permissions granted to roles.

Roles granted to other roles.

select * 
from role_role_privs 
where role in (select granted_role from dba_role_privs where grantee= :username)
  1. system privileges
select * 
from role_sys_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)
  1. object grants
select * 
from role_tab_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)