Home » SQL & PL/SQL » SQL & PL/SQL » how to view all created users of sql (oracle).
how to view all created users of sql (oracle). [message #187114] Thu, 10 August 2006 23:01 Go to next message
youthsen
Messages: 45
Registered: August 2006
Member
hi pals

is there any command to do this.

pls help me.

very urgent.

thanks a lot in advance.
Re: how to view all created users of sql (oracle). [message #187117 is a reply to message #187114] Thu, 10 August 2006 23:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
SQL> select username from dba_users;
Re: how to view all created users of sql (oracle). [message #187138 is a reply to message #187114] Fri, 11 August 2006 01:53 Go to previous messageGo to next message
gbarbisan
Messages: 67
Registered: August 2006
Location: Treviso - Italy
Member
SELECT *
  FROM ALL_USERS;
Re: how to view all created users of sql (oracle). [message #187211 is a reply to message #187114] Fri, 11 August 2006 05:46 Go to previous messageGo to next message
pamrajrajeev
Messages: 9
Registered: July 2006
Junior Member
Working in administrator mode, u can give the command as


SELECT * FROM DBA_USERS;



Regards


Rajeev
Re: how to view all created users of sql (oracle). [message #187240 is a reply to message #187211] Fri, 11 August 2006 07:48 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I really think the OP got an idea after the first post...
Re: how to view all created users of sql (oracle). [message #187274 is a reply to message #187240] Fri, 11 August 2006 10:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
My sentiments exactly Frank. Guess we need a sticky directing responders to READ the previous responses PRIOR to responding. Of course, if they don't read the responses what makes me think they will read a sticky ??
Re: how to view all created users of sql (oracle). [message #187289 is a reply to message #187114] Fri, 11 August 2006 12:50 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
The second reply is valid. If they were not a dba user, the first select would fail. However, the third one was not necessary.
Re: how to view all created users of sql (oracle). [message #187324 is a reply to message #187114] Sat, 12 August 2006 02:46 Go to previous message
youthsen
Messages: 45
Registered: August 2006
Member
hi buddeis

thanks a lot for the replies
Previous Topic: how to change the password for particular user in sql
Next Topic: Composite index usage
Goto Forum:
  


Current Time: Fri Dec 09 17:20:45 CST 2016

Total time taken to generate the page: 0.26420 seconds