4 Replies Latest reply: Dec 30, 2013 2:21 AM by Inigo RSS

SYS account status

Inigo Newbie
Currently Being Moderated

Hi all,

 

     Sys account status couldn't be changed even the  password life time exceeds.......

 

thanks in advance...

  • 1. Re: SYS account status
    Justin Cave Oracle ACE
    Currently Being Moderated

    I don't understand.  Are you asking a question?  Or making a statement?  I'm not sure what "status" you are referring to.

     

    Justin

  • 2. Re: SYS account status
    Inigo Newbie
    Currently Being Moderated

    hi Justin,

     

         thanks for your response...

         i m asking Question......

     

         still i can able to login sys account ..... even though that account got expired or locked............

     

         why it is behaving like this......

     

         I tested this behavior in DEFAULT profile and my own customized profile also..........

  • 3. Re: SYS account status
    Justin Cave Oracle ACE
    Currently Being Moderated

    SYS is special (in this and in many other respects).  It wouldn't make sense to be able to lock out the SYS account because that potentially makes your database less usable if there are no other SYSDBA accounts in place.  It's the same way that you're realistically not going to be able to lock the root account on a Unix system.

     

    Justin

  • 4. Re: SYS account status
    Inigo Newbie
    Currently Being Moderated

    Thanks justin.

     

    Thanks for your response.

     

    I can able to lock the sys account..... by SYS user itself.... and i can able to login  as SYS user.... it is not at all throwing the error

    ERROR:

    ORA-28000: the account is locked

     

    G:\>sqlplus sys/oracle as sysdba

    SQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 30 15:24:54 2013

    Copyright (c) 1982, 2011, Oracle.  All rights reserved.

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning option

     

    SQL> select username,account_status from dba_users where username like 'SYS';

    USERNAME                       ACCOUNT_STATUS

    ------------------------------ --------------------------------

    SYS                            LOCKED

     

    SQL> disc

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning option

    SQL> conn sys as sysdba

    Enter password:

    Connected.

    SQL> grant sysdba to go;

    Grant succeeded.

    SQL> select username,account_status from dba_users where username like 'SYS' or username like 'GO';

    USERNAME                       ACCOUNT_STATUS

    ------------------------------ --------------------------------

    GO                             LOCKED

    SYS                            LOCKED

    SQL> conn go/go

    ERROR:

    ORA-28000: the account is locked

     

     

     

     

    Warning: You are no longer connected to ORACLE.

    SQL> conn go as sysdba

    Enter password:

    Connected.

    SQL>

     

    It may be, because this SYSDBA privillege that accounts are reactting like this....

     

    Thanks again justin....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points