Otherwise. no way...Code:SQL> select account_status from dba_users where username='THOMAS'; ACCOUNT_STATUS -------------------------------- OPEN SQL> alter user thomas account lock; User altered. SQL> select account_status from dba_users where username='THOMAS'; ACCOUNT_STATUS -------------------------------- LOCKED SQL> alter user thomas account unlock; User altered. SQL> select account_status from dba_users where username='THOMAS'; ACCOUNT_STATUS -------------------------------- OPEN SQL> alter user thomas password expire; User altered. SQL> select account_status from dba_users where username='THOMAS'; ACCOUNT_STATUS -------------------------------- EXPIRED SQL> alter user thomas identified by thomas; User altered. SQL> select account_status from dba_users where username='THOMAS'; ACCOUNT_STATUS -------------------------------- OPEN




Reply With Quote