oracle密码策略管理
成功安装oracle后会有一个默认密码略，比如用户的密码有效期和锁定策略...，在默认情况下oracle用户密码有效期是180天，失败登录尝试次数最大10次然后就被锁定。如果想密码有效期设置用于都有效、用户可以无限次去尝试登录，这时候需要修改下默认策略
查看oracle默认的密码有效期策略（180天）
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIMEPASSWORD
180
设置oracle默认策略为永久有效
SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
再次查看
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIMEPASSWORD
UNLIMITED
查看oracle默认密码锁定策略
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTSPASSWORD
设置为无数次
SQL> Alter PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTSUNLIMITED;
Profile altered.
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTSPASSWORD
UNLIMITED
SQL> commit
2;
Commit complete.
页:
[1]