Alter user to lock or unlock the account : Lock Unlock Account « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. Lock Unlock Account

Alter user to lock or unlock the account

SQL> create user oracle_admin  identified by oracle_admin;

User created.

SQL>
SQL> grant create session, dba to oracle_admin;

Grant succeeded.

SQL>
SQL> alter user oracle_admin account lock;

User altered.

SQL>
SQL> alter user oracle_admin account unlock;

User altered.

SQL>
SQL> -- connect oracle_admin/oracle_admin;
SQL>
SQL> DROP USER oracle_admin;

User dropped.

SQL>

           
       

Related examples in the same category