RE: Find DBA users

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Mon, 26 Nov 2001 06:07:24 -0800
Message-ID: <F001.003CCAD9.20011126054024@fatcity.com>

<SPAN

class=107103813-26112001>Try
select grantee from dba_role_privs where granted_role = 'DBA'
<SPAN

class=107103813-26112001>John
 

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Daiminger, Helmut   [mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: 26 November 2001   12:10To: 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

---

This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium.

---

Received on Mon Nov 26 2001 - 08:07:24 CST