OraFAQ Forum: Security » so many users

Home » RDBMS Server » Security » so many users

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

so many users [message #135370]

Wed, 31 August 2005 05:46

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi,

I just want to know why i have so many extra users in the database ?

Quote:

SQL> select distinct(username) from dba_users

USERNAME
------------------------------
ANONYMOUS
ARUN ---> Created
CTXSYS
DBSNMP
MDSYS
ORDPLUGINS
ORDSYS
OUTLN
RAJESH ---> Created

USERNAME
------------------------------
SCOTT ---> Created
SUDHAR ---> Created
SYS
SYSTEM
TANU ---> Created
WMSYS
XDB

18 rows selected.

SYS and SYSTEM are fine but why so many users exist in the database by default.

Is it necessary to keep these users in the database ?
Could anyone give me some documentation or link to read about this.
The requirement is because i want to show all stored procedures from dba_source view and i want to exclude the unnecessary users.

thanks,
tarun

Report message to a moderator

Re: so many users [message #135408 is a reply to message #135370]

Wed, 31 August 2005 08:16

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

Senior Member
Account Moderator

>> I just want to know why i have so many extra users in the database ?

They are not extra users or zombies.
While creating the database you have asked the DBCA to go with default options that inlcude XMLDB,Intermedia etc.
Please see here
http://www.orafaq.com/forum/m/55276/0/?srch=Oracle+Text+option+is+installed#msg_55276

Report message to a moderator

Re: so many users [message #135524 is a reply to message #135408]

Thu, 01 September 2005 00:05

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Thanks a lot Mahesh.

Got it .

tarun

Report message to a moderator

Previous Topic:	How to hide not-owned tables from users?
Next Topic:	any password works!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 23:03:54 CST 2025