RE: Find out what sys privileges a user has

If all you want to see are the privileges on sys owned packages:

select grantee, privilege, table_name from dba_tab_privs where owner='SYS' order by table_name, grantee, privilege;

now, if you want to see who they got the privilege from, include grantor in the select string.

DBA_TAB_PRIVS contains the grants on all objects -- tables, sequences, procedures, packages, functions etc

DBA_SYS_PRIVS contains the system privileges granted to a user -- create table, create session, etc

DBA_ROLE_PRIVS contains the roles that a particular user (or role) can assume

Rachel
>From: "Mark Leith" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Find out what sys privileges a user has
>Date: Tue, 09 Jan 2001 06:56:32 -0800
>
>Why not take a look at DBA_SYS_PRIVS and DBA_TAB_PRIVS, these should give
>you the info you are looking for..
>
>HTH
>
>Mark
>
>-----Original Message-----
>Sent: Tuesday, January 09, 2001 11:56
>To: Multiple recipients of list ORACLE-L
>
>
>How can I find out what privileges a user has on what sys packages, (from
>sqlplus command line)
>
>John
>.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
>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).