SQL>conn /as sysdba SQL>select password from dba_users where username='SCOTT'; password ------------------------------ E65E6AF62B2449CF SQL>alter user SCOTT identified by values 'E65E6AF62B2449CF';
SQL> select name,ASTATUS,password from user$ where name IN('SYS','SCOTT'); NAME ASTATUS PASSWORD ------------------------------ ---------- ------------------------------ SCOTT 1 E65E6AF62B2449CF SYS 0 8A8F025737A9097A SQL> select username,account_status from dba_users where username in('SYS','SCOTT'); USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SCOTT EXPIRED
SQL> UPDATE USER$ SET ASTATUS=0 WHERE NAME='SCOTT'; 1 row updated. SQL> COMMIT; Commit complete. SQL> alter system flush shared_pool; System altered.
再來觀察結果:
SQL> select name,ASTATUS,password from user$ where name IN('SYS','SCOTT'); NAME ASTATUS PASSWORD ------------------------------ ---------- ------------------------------ SCOTT 0 E65E6AF62B2449CF SYS 0 8A8F025737A9097A SQL> select username,account_status from dba_users where username in('SYS','SCOTT'); USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SCOTT OPEN SYS OPEN