oracle学习之:解锁用户

来源:互联网 发布:流量互换源码 编辑:程序博客网 时间:2024/06/04 01:39

解锁语法:

alter user user_name identified by password account unlock;

例如: 解锁,用户:scott,密码:tiger

SYS@ORA11GR2> conn scott/tigerERROR:ORA-28000: the account is lockedWarning: You are no longer connected to ORACLE.
SYS@ORA11GR2> alter user scott identified by tiger account unlock;User altered.SYS@ORA11GR2> conn scott/tigerConnected.SCOTT@ORA11GR2> 
0 0
原创粉丝点击