| Drop installation time created users [message #56023] |
Mon, 03 March 2003 04:48  |
Manu Gupta
Messages: 44
Registered: January 2002
|
Member |
|
|
Hello All,
I have production database server with Oracle 8.1.7 installed on Windows NT.
I want to know that should I keep following users created at the time of
installation or drop them. I am not using any 8i feature and use is limited
or equal to 7.3 or 8.0 versions.
OUTLN
DBSNMP
AURORA$JIS$UTILITY$
OSE$HTTP$ADMIN
AURORA$ORB$UNAUTHENTICATED
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS
MTSSYS
Kindly also let me know side effects of dropping these users.
Thanks
Manu
|
|
|
|
| Re: Drop installation time created users [message #56025 is a reply to message #56023] |
Mon, 03 March 2003 05:09  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
you can drop some of them... CTXSYS etc which relates to the context server, but some you should not drop (DBSNMP for example).
Have a look on metalink for full details - there will be scripts in $ORACLE_HOME/rdbms/admin to drop them 'correctly', you just need to identify the correct scripts.
One thing... maybe you could have a look at what you installed when you first installed the Oracle software and next time, only install the parts you need ;-)
Personally, I'd just leave them there - they don't take up much space and 'if it's not broke, don't fix it' ;-)
Thats my 2p ;-)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
