Friday, February 24, 2017

oracle lock system account


SQL> show user
USER is "SYS"
SQL
> alter user sys account lock;

User altered.

SQL
> select account_status from dba_users where username = 'SYS';

ACCOUNT_STATUS
--------------------------------
LOCKED

SQL
> conn / as sysdba
Connected
.
SQL
> show user
USER is "SYS"

SQL
> connect sys@ORCL as sysdba
Enter password
:
Connected
.

SQL
> show user
USER is "SYS"
SQL
> select account_status from dba_users where username = 'SYS';

ACCOUNT_STATUS
--------------------------------
LOCKED

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...