What's the impact, if I lock the account "scott" [message #56450] |
Mon, 31 March 2003 23:01 |
Felix
Messages: 6 Registered: February 2002
|
Junior Member |
|
|
Hi:
The oracle8.1.7 was installed in my Sun Cluster Sever,
OS is Solaris 8.
After I locked the "scott" account, some processes began hang on the memory for a long time.
Is there any impact if the account "scott" was been locked. thank you.
Felix
|
|
|
Re: What's the impact, if I lock the account "scott" [message #56451 is a reply to message #56450] |
Tue, 01 April 2003 01:16 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi Felix,
so far I know is there no impact. scott is a demo user createtd automatic by oracle. But if some developers create software which need this account you may have impact.
scott may be an security whole, because anybody knows the password. There are some other user which are dummy-created like dbsnmp and outln.
regards
Uwe
|
|
|
Re: What's the impact, if I lock the account "scott" [message #56454 is a reply to message #56450] |
Tue, 01 April 2003 06:06 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
EVERY DEFAULT USER CREATED BY ORACLE HAS A PURPOSE ( which is ofcourse optional) except for sample/demo schema's like SCOTT.
There should no harm in locking SCOTT.
But, dont drop or lock the following accounts,
UNLESS u are clear that these options are NOT USED.
Oracle adds the OUTLN user schema to support Plan Stability. The OUTLN user acts as a place to centrally manage metadata associated with stored outlines.
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
OLAPSYS if OLAP option is installed
|
|
|