我要评论oracle11g密码复杂性校验开启关闭
oracle11g密码复杂性校验由参数password_verify_function控制
开启密码复杂性校验
sql> @?/rdbms/admin/utlpwdmg.sql function created. grant succeeded. profile altered. function created. grant succeeded. select * from dba_profiles d where d.profile='default';
sql> alter user syd identified by syd; alter user syd identified by syd * error at line 1: ora-28003: password verification for the specified password failed ora-20001: password length less than 8 sql> alter user syd identified by sydoracle123; user altered. sql> alter user syd identified by syd; alter user syd identified by syd * error at line 1: ora-28003: password verification for the specified password failed ora-20001: password length less than 8
关闭密码复杂性校验
sql> alter profile default limit password_verify_function null; profile altered. select * from dba_profiles d where d.profile='default';
sql> alter user syd identified by syd; user altered. sql> alter user syd identified by oracle; user altered.
utlpwdmg.sql脚本中有如下一段内容：
alter profile default limit password_life_time 180 password_grace_time 7 password_reuse_time unlimited password_reuse_max unlimited failed_login_attempts 10 password_lock_time 1 password_verify_function verify_function_11g;
运行了以上脚本后，在开启了密码校验性的同时，oracle密码期限也被改回了默认的180天，若需要密码不过期别忘更改：
sql> alter profile default limit password_life_time unlimited; profile altered.
总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持代码网。
发表评论