OraFAQ Forum: Security » What's the impact, if I lock the account "scott"

Home » RDBMS Server » Security » What's the impact, if I lock the account "scott"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 09 14:44:08 CDT 2025