Select * from dba_sys_privs where grantee='R1';
Select * from dba_tab_privs where grantee='R1';
Select * from dba_tab_privs where owner='schema' and
table_name='table_name';
-Original Message-
Sent: Tuesday, September 09, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Hi List
:
@fcg.comSubject: RE: Privileges associated with
Role
Sent by:
ml-errors
I should have read your question more closely. The grants script that I
provided will also work with a role instead of a userid.
To get all the privileges granted on a table select * from dba_tab_privs
where table_name = 'TABLE_YOU'RE_INTERESTED_IN';
dba_sys_privs
role_sys_privs
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 21:44
Hi List
How to look for all the privileges associated with
particular Role(for example R1)?
--
Please see the official ORACLE-L
Hi
I wrote script some time back that you use to find all privileges
granted to a user or role, system, object and role. It does this
hierarchically so that it shows privs granted to roles granted to roles
etc. It is available from http://www.petefinnigan.com/tools.htm its the
first script