OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » find default user

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

find default user [message #220120]

Sun, 18 February 2007 23:32

oracle_coorgi
Messages: 188
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;

Report message to a moderator

Re: find default user [message #220122 is a reply to message #220120]

Sun, 18 February 2007 23:53

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

oracle_coorgi
Messages: 188
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...

Report message to a moderator

Re: find default user [message #220358 is a reply to message #220303]

Tue, 20 February 2007 06:38

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: find default user [message #220360 is a reply to message #220358]

Tue, 20 February 2007 06:53

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Previous Topic:	Migration from MSSQL SERVER 2000 to ORACLE 10G
Next Topic:	NoBody is there for MIgration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:51:36 CDT 2024