4 Replies to “lock sys”

  1. So if you lock all accounts in the database (incl. SYS) and then log out, can you still get in then?…

  2. Using the role ‘sysdba’ is not really the same like ‘sys’.
    One thing it’s not possible to grant rights to the dictionary:

    newsysadm@db01> grant select on sys.dba_users to new_user;
    ORA-1031 insufficient privileges

    That’s to keep in mind! 🙂

    Nevertheless a good article!!! :):):)

  3. SYSDBA is connecting as SYS

    
    SQL> grant sysdba to newsysadm;
    Grant succeeded.
    SQL> conn newsysadm/***@DB01 as sysdba
    Connected.
    SQL> sho user
    USER is "SYS"
    SQL> grant select on sys.dba_users to new_user;
    Grant succeeded.
    SQL> 
    

    Don’t confuse role DBA and administrative privilege SYSDBA.
    Maybe of interest : sysdba

Leave a Reply

Your email address will not be published.

*