OraFAQ Forum: SQL & PL/SQL » user in database

Home » SQL & PL/SQL » SQL & PL/SQL » user in database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user in database [message #1846]

Tue, 04 June 2002 06:50

aura
Messages: 1
Registered: June 2002

Junior Member

I need to find out which users are in the database. What command do I need?

thanks alot

Report message to a moderator

Re: user in database [message #1848 is a reply to message #1846]

Tue, 04 June 2002 07:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator


SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
AURORA$ORB$UNAUTHENTICATED
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS
SCOTT
ADAMS
JONES
CLARK
BLAKE
MAG

15 rows selected.

SQL>

Report message to a moderator

Previous Topic:	URGENT pls..Inserting Image using LONG RAW in oracle7.3
Next Topic:	running an sql script file??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:25:47 CDT 2024