OraFAQ Forum: Server Utilities » How to know if a user exist?

Home » RDBMS Server » Server Utilities » How to know if a user exist?

Tue, 15 June 2004 19:36

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

I want to create a user if it is not existed.

However, how to judge if it is been created?

Thanks!

Wed, 16 June 2004 03:24

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

Senior Member
Account Moderator

check dba_users.username

Wed, 16 June 2004 17:29

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

Error: SP2-0734
Unknow command line.

Thu, 17 June 2004 03:02

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

Senior Member
Account Moderator

-- check whether your USER is listed here
-- login as a DBA user or sys or system

sql>select username from dba_users;

Previous Topic:	bad performance in import when table created previously
Next Topic:	SQLLDR: path of the file!

Goto Forum:

]

Current Time: Mon Jul 01 02:34:00 CDT 2024