Oracle Database Data Dictionary Privilege information
Example
All roles granted to user.
select *
from dba_role_privs
where grantee= :username
Privileges granted to user:
- system privileges
select *
from dba_sys_privs
where grantee = :username
- 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)
- system privileges
select *
from role_sys_privs
where role in (select granted_role from dba_role_privs where grantee= :username)
- object grants
select *
from role_tab_privs
where role in (select granted_role from dba_role_privs where grantee= :username)
