This content has been marked as final. Show 6 replies
-- select all the role name and granted role
order by 1;
-- select all the roles and their privilages
where ROLE = 'TABQ'
order by 1;
-- show all object privilages in a role
where role = 'TABQ';
Status Level: Newbie
Registered: Feb 24, 2010
Total Posts: 20
Total Questions: *7 (6 unresolved)*
-- Mark your helpful post as correct/helpful and close all the answered threads.
You can use the below views to find role related informations,
DBA_ROLE_PRIVS - Roles granted to users and roles
ROLE_ROLE_PRIVS - Roles which are granted to roles
ROLE_SYS_PRIVS - System privileges granted to roles
ROLE_TAB_PRIVS - Table privileges granted to roles
Also query from
Oracle online manual are available. Just spend some time...
- Pavan Kumar N
user9212851 wrote:When you've checked the manuals and identified the views suggested by other posters you will find that it's still not a trivial problem since a role may be granted to another role - which means you need to do some recursion to uncover all the privileges available to a role.
Can you please let me know how to check the privileges assigned to a role in Oracle?
When I query the dba_tab_privs it says no rows returned.
Pete Finnigan - who specialises in Oracle security - published some appropriate scipts a few years ago; they are probably still relevant. Here's a starting link: http://www.petefinnigan.com/weblog/archives/00001243.htm
Privileges assigned to a role
select * from dba_sys_privs where grantee='DBA'
/* here DBA is role name */
privileges and roles assigned to user
Select a.grantee User_name, a.granted_role role, b.privilege from DBA_ROLE_PRIVS a, DBA_SYS_PRIVS b where
a.granted_role=b.grantee and a.grantee='SCOTT'
Edited by: Ravi Kumar Pilla on Feb 25, 2011 10:57 PM