Thursday, June 28, 2012

how to unlock scott user in oracle 10g

login with sqladmin account or other account

SQL> alter user scott account unlock;
User altered.
SQL> alter user scott identified by tiger;
User altered.

No comments: