Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Security & deletable users
Hi John,
DBSNMP should not be deleted if you want to use Oracle Enterprise Manager.
There is a script in $ORACLE_HOME/rdbms/admin to drop it (something like
snmpdrp)
SYS is the owner of the datadictionary, definitely not to be deleted.
SYSTEM is the owner of many repositories and should not be deleted
SCOTT is the Oracle provided demo user. It takes very little space, and I
shouldn't delete it.
The other users I don't know.
Questions like this indicate you are indeed a newbie. I won't repeat that
four letter abbreviation, but you are well advised to do it.
Hth,
Sybrand Bakker, Oracle DBA
John M wrote:
> Oracle NT 8.0 Quikie: Which users are installed by default,
> and therefore should not be deleted?
> DBSNMP ?
> DEMO deletable ?
> MDSYS ?
> ORDSYS ?
> SCOTT deletable ?
> SYS not !?!
> SYSTEM not !?!
> TONINATO deletable ?
> JOBSITE deletable ?
>
> What other tips or gotchas might apply to putting O8 on the
> hot side of a firewall?
> I've used informix/irix, sybase/nt, sqlbase/netware,
> and am a raw oracle newbie...
>
> TIA john
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 29 1999 - 15:13:21 CST