我们可以通过视图dba_users查看当前数据库的用户和状态信息:
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
OUTLN EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
假设我们希望将用户OUTLN解锁,执行
SQL> alter user outln account unlock;
User altered.
为用户修改密码:
SQL> alter user outln identified by outln;
User altered.
SQL> conn outln/outln
Connected.
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
OUTLN EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
SQL> alter user outln account unlock;
User altered.
为用户修改密码:
SQL> alter user outln identified by outln;
User altered.
SQL> conn outln/outln
Connected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29800581/viewspace-1252016/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29800581/viewspace-1252016/