Home » RDBMS Server » Security » so many users
so many users [message #135370] Wed, 31 August 2005 05:46 Go to next message
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
Re: so many users [message #135408 is a reply to message #135370] Wed, 31 August 2005 08:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
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
Re: so many users [message #135524 is a reply to message #135408] Thu, 01 September 2005 00:05 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Thanks a lot Mahesh.

Got it .

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


Current Time: Wed Sep 22 12:18:27 CDT 2021