Try
select grantee from dba_role_privs where granted_role = 'DBA'
John
-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2001 12:10
To: Multiple recipients of list ORACLE-L
Subject: Find DBA usersHi!
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
**********************************************************************
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.
**********************************************************************
