Oracle-L: System tables for generating the object privileges

From: Vasu Ramasamy <vasu.ramasamy_at_sri.com>
Date: Tue, 21 May 2002 18:03:22 -0800
Message-ID: <F001.00466FD4.20020521180322@fatcity.com>

Hello All,

I am trying to generate a script to grant privileges on the DB objects by extracting them from system tables. I know that the following system tables can be used to get the system, role privileges, and table and column access privileges. dba_sys_prives

    dba_roll_prives
    dba_tab_privs
    dba_col_privs

I am not able to find the system tables to get the privileges assigned to users on stored procedures, views and synonyms etc. Can you please throw some light on this?

Thanks for your help.

Vasu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vasu Ramasamy
INET: vasu.ramasamy_at_sri.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Tue May 21 2002 - 21:03:22 CDT