Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Find DBA users

RE: Find DBA users

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Mon, 26 Nov 2001 06:52:39 -0800
Message-ID: <F001.003CCB40.20011126055021@fatcity.com>

 select grantee from

dba_role_privs where granted_role = 'DBA';
 

<SPAN
class=036144413-26112001>Dave

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Daiminger, Helmut   [mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: Monday, November 26,   2001 6:10 AMTo: Multiple recipients of list   ORACLE-LSubject: Find DBA users
  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, <FONT face=Arial
  size=2>Helmut Received on Mon Nov 26 2001 - 08:52:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US