How to lock or unlock Oracle user account?
Posted: Sat Jan 21, 2012 5:32 am
To lock an Oracle user account, follow the below procedure:
Login to database with SYS privileges.
sqlplus '/as sysdba'
SQL> alter user <username> account lock;
e.g. SQL> alter user HR account lock;
Verify the account status:
SQL> select username,account_status,created from dba_users where username ='HR';
To unlock an Oracle user account, follow the below procedure:
Login to database with SYS privileges.
sqlplus '/as sysdba'
SQL> alter user <username> account unlock;
e.g. SQL> alter user HR account unlock;
SQL> select username,account_status,created from dba_users where username ='HR';
Login to database with SYS privileges.
sqlplus '/as sysdba'
SQL> alter user <username> account lock;
e.g. SQL> alter user HR account lock;
Verify the account status:
SQL> select username,account_status,created from dba_users where username ='HR';
To unlock an Oracle user account, follow the below procedure:
Login to database with SYS privileges.
sqlplus '/as sysdba'
SQL> alter user <username> account unlock;
e.g. SQL> alter user HR account unlock;
SQL> select username,account_status,created from dba_users where username ='HR';