Home » RDBMS Server » Security » What's the impact, if I lock the account "scott"
What's the impact, if I lock the account "scott" [message #56450] Mon, 31 March 2003 23:01 Go to next message
Messages: 6
Registered: February 2002
Junior Member
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.

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 Go to previous messageGo to next message
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.
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 Go to previous message
Mahesh Rajendran
Messages: 10697
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$JIS$UTILITY$       if Oracle Servlet Engine (OSE) is installed   
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   

Previous Topic: audit disable how to
Next Topic: enabling auditing!
Goto Forum:

Current Time: Sun May 22 13:02:09 CDT 2022