to find privilege for a role

[joe_kk]

how to find what are the privilege given for a role

Thanks

[santoshym]

Hi Joe,

Try this

Login in as sys and type the following command

select grantee,granted_role from dba_role_privs;

offcourse there is another couple of tables called as user_role_privs and role_role_privs

select username,granted_role from user_role_privs;

select role,granted_role from role_role_privs;


Hope this helped

Regards

[Edited by santoshym on 05-31-2001 at 05:17 PM]

[jmodic]

Originally posted by santoshym
select grantee,granted_role from dba_role_privs;

offcourse there is another couple of tables called as user_role_privs and role_role_privs

select username,granted_role from user_role_privs;

select role,granted_role from role_role_privs;

The above will only list which roles have been granted to users and to other roles. It does not tell which system and object privileges have been granted to roles.

I belive what Joe was asking for was to list all the system and object privileges that have been granted to a particular role. For example, to find out which privileges have been granted to DBA role, use the following two statements:

SELECT table_name, privilege FROM dba_tab_privs WHERE grantee = 'DBA';

SELECT privilege FROM dba_sys_privs WHERE grantee = 'DBA';