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';
Oracle DBA
<sami_resume To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
@yahoo.com> cc:
Sent by: Subject: Privileges associated with
Role
ml-errors
09/09/2003 12:14
PM
Please respond
to ORACLE-L
Hi List
How to look for all the privileges associated with
particular Role(for example R1)?
Alos does anyone have a query to identify ALL(either
directly or thru role) the privileges granted on
particular tables
TIA
Sami
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
