Home » RDBMS Server » Server Administration » find default user
find default user [message #220120] Sun, 18 February 2007 23:32 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
how can i find the default user created ,when oracle 10g is installed in windows
sql>select username,user_id from dba_users;
Re: find default user [message #220122 is a reply to message #220120] Sun, 18 February 2007 23:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
how can i find the default user created
Which Default User ?

you can query how many user exists in your database after database creation.
select username, account_status from dba_users;




regards
Taj

[Updated on: Sun, 18 February 2007 23:54]

Report message to a moderator

Re: find default user [message #220303 is a reply to message #220122] Tue, 20 February 2007 02:52 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
i want see oracle genrated user not all user
eg:scott,system,hr,pm etc...
i want see only user created user not oracle genrated user not all user like:scott,system,hr,pm etc...
Re: find default user [message #220358 is a reply to message #220303] Tue, 20 February 2007 06:38 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
user created user not oracle genrated user not all user

Do you understand what you've just said? I don't.
Re: find default user [message #220360 is a reply to message #220358] Tue, 20 February 2007 06:53 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
THe OP must be looking for the custom schemas and not the System created/optional schemas.
@OP
Oracle will create those schema if you chose to use options during installation.
THere is no specific method to display/query only the custom users. But all the system crated ones are documented.

http://www.orafaq.com/forum/m/55276/0/?srch=Oracle+Text+option+is+installed#msg_55276

all the sample schemas are listed here
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14198/toc.htm
Previous Topic: Migration from MSSQL SERVER 2000 to ORACLE 10G
Next Topic: NoBody is there for MIgration
Goto Forum:
  


Current Time: Wed Dec 07 18:31:57 CST 2016

Total time taken to generate the page: 0.08985 seconds