Oracle PL/SQL/User Previliege/Lock Unlock Account

Alter user to lock or unlock the account

   <source lang="sql">

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>

      </source>
   
  

unlock user

   <source lang="sql">

alter user joe account unlock;

</source>