oracle用户解锁

来源：互联网发布：4399皮卡堂刷金卡软件编辑：程序博客网时间：2024/05/16 07:57

Scott用户被锁定

SQL> conn scott/tiger;ERROR:ORA-28000: the account is locked

切换sys用户，查看被锁定用户scott信息

SQL> conn sys/syssys;Connected.SQL> select username,lock_date from dba_users where username='SCOTT';USERNAME                       LOCK_DATE----------------------------- ----------SCOTT                          29-DEC-15

查看FAILED_LOGIN_ATTEMPTS的值(默认用户密码错误输入10次后会被锁定)

SQL>  select * from dba_profiles……PROFILE    RESOURCE_NAME         RESOURCE    LIMIT-------- ----------------------- ---------- ------DEFAULT    FAILED_LOGIN_ATTEMPTS PASSWORD    10……

设定为30次，用户密码错误输入30次后会被锁定

SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 30;

解锁scott用户

SQL> alter user scott account unlock;User altered.

登录scott用户，正常了

SQL> conn scott/tiger;Connected.SQL> show user;USER is "SCOTT"

0 0