示例3:
SQL>select username,account_status,lock_date from dba_users;
USERNAME ACCOUNT_STATUS LOCK_DTAE
--------------------------------------------------------------------------------------
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
HOUSE OPEN
SCOTT OPEN
OE OPEN
OUTLN EXPIRED&LOCKED 18-8月 -07
WMSYS EXPIRED&LOCKED 18-8月 -07
ORDSYS EXPIRED&LOCKED 18-8月 -07
MDSYS EXPIRED&LOCKED 18-8月 -07
2 使用ALTER USER解锁被锁住的MDSYS用户。
SQL>show user;
USER 为“SYSTEM”
SQL>alter user MDSYS account unlock;
用户已更改。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23466814/viewspace-629454/ ,如需转载,请注明出处,否则将追究法律责任。