SQL> select username,account_status from dba_users where username='DIP';
USERNAME ACCOUNT_STATUS
----------------------- ---------------
SCOTT EXPIRED & LOCKED
SQL> alter user SCOTT account unlock;
User altered.
SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT EXPIRED
SQL> select password from dba_users where username='SCOTT';
PASSWORD
------------------------------
CE4A36B8E06CA59C
SQL> alter user scott identified by values 'CE4A36B8E06CA59C';
User altered.
SQL> select username,account_status from dba_users where username='SCOTT';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT OPEN
No comments:
Post a Comment