Thursday, 15 March 2012

How to unlock user account in Oracle SQL Plus

1] Open SQL Plus

2] Login as SYSDBA
SQL> conn /as sysdba

3] Unlock the account
SQL> ALTER USER username ACCOUNT UNLOCK;


To lock the account

SQL> ALTER USER username ACCOUNT LOCK;

No comments:

Post a Comment

About Us | Site Map | Privacy Policy | Contact Us | Blog Design | 2007 Company Name