我们可以通过视图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博客 ” ，链接：https://blog.itpub.net/29800581/viewspace-1252016/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle自动归档的设置
下一篇：
通过oracle的脚本研究其建库过程
请登录后发表评论
登录
全部评论
