| Default Users in 9i ? Urgent [message #55222] |
Sun, 12 January 2003 02:58  |
K. Prakash babu
Messages: 46
Registered: July 2001
|
Member |
|
|
I am facing some space problems in my Database. I need to remove some default users from the follwing. I am giving here the list of all the default users. By Excluding SYS, SYSTEM & PROCESSES, which other users can i drop without being any harm to my database?
SYS,SYSTEM,DBSNMP,SCOTT,OUTLN,WMSYS,ORDSYS,
ORDPLUGINS,MDSYS,CTXSYS,QS_OS,QS_ES,QS_WS
QS,QS_ADM,SH,PM,OE,QS_CS,QS_CB,QS_CBADM,XDB ANONYMOUS,WKSYS,WKPROXY,ODM,ODM_MTR,OLAPSYS
Thanx in Advance
|
|
|
|
| Re: Default Users in 9i ? Urgent [message #55276 is a reply to message #55222] |
Wed, 15 January 2003 09:31  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
it actually depends on OPTIONS your are using.
If you arenot using any sample databases
you drop scott, Hr et.
if you are not using oracle dataming features in 9i,
drop ODM etc
DBSNMP if Enterprise Manager Intelligent Agent is installed
TRACESVR if Enterprise Manager is installed
AURORA$ORB$UNAUTHENTICATED AURORA$JIS$UTILITY$ -- if Oracle Servlet Engine (OSE) is installed
OSE$HTTP$ADMIN/MDSYS if Oracle Spatial option is installed
ORDSYS if interMedia Audio option is installed
ORDPLUGINS if interMedia Audio option is installed
CTXSYS if Oracle Text option is installed
REPADMIN if Replication Option is installed
LBACSYS if Oracle Label Security option is installed
ODM if Oracle Data Mining option is installed
ODM_MTR idem OLAPSYS if OLAP option is installed
WMSYS if Oracle Workspace Manager script owmctab.plb is executed.
ANONYMOUS if catqm.sql catalog script for SQL XML management
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
