数据库用户别锁定了
数据库用户别锁定了
数据库用户别锁定了
1)查看数据库默认锁定次数
[sql]- SQL> set linesize 2000
- SQL> select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
- PROFILE RESOURCE_NAME RESOURCE LIMIT
- ------------------------------ -------------------------------- -------- ----------------------------------------
- DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
- MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
2)查看上次被锁定的时间
[sql]- SQL> select LOCK_DATE,username from dba_users where username='JSCN';
LOCK_DATE, username
----------------- ------------------
2012/2/6 13:36:10 JSCN
3)设置系统的默认登录次数
[sql]
- SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS 10; --连续重试10次锁定
- Profile altered.
- SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED; --不锁定
- Profile altered.
4)解锁
[sql]
- SQL> alter user jscn account unlock;
- User altered.
评论暂时关闭