Re: Find DBA users

Check view dba_sys_privs

Mujeeb Chowdhry

>>> Helmut.Daiminger_at_KirchGruppe.de 11/26/01 07:10AM >>>
Hi!

Is there a data dictionary view that gives me all users who have geen granted the DBA role?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mujeeb Chowdhry
  INET: mujeeb.chowdhry_at_nara.gov

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).