Home » SQL & PL/SQL » SQL & PL/SQL » DBA users
DBA users [message #210146] Tue, 19 December 2006 10:44 Go to next message
assoora28
Messages: 18
Registered: December 2006
Location: Jordan
Junior Member

hi

How to know the DBA user in my oracle database, coz i 4got it?
Re: DBA users [message #210253 is a reply to message #210146] Wed, 20 December 2006 01:03 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You would query the users who have been granted the DBA role:
SQL> select grantee
  2  from   dba_role_privs
  3  where  granted_role = 'DBA'
  4  /


MHE
Previous Topic: DROP ALL THE TABLES WITH A SINGLE QUERY
Next Topic: row into column
Goto Forum:
  


Current Time: Mon Dec 05 19:29:48 CST 2016

Total time taken to generate the page: 0.06642 seconds