安全第二手 设置密码复杂度 verify

关键是pdb情况下
得要逐个登录pdb，然后再设置profile

alter session set container=pdb1;


set lines 200 pages 1000
col PROFILE for a10
col RESOURCE_NAME for a30
col RESOURCE_TYPE for a20
col LIMIT for a23
select PROFILE,RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where RESOURCE_TYPE='PASSWORD' and PROFILE='DEFAULT';

alter profile default limit PASSWORD_VERIFY_FUNCTION verify_function;

然后再检查确认
select username,account_status,profile from dba_users;

create user abcdef identified by abcdef;
如果失败说明复杂度设置成功

还可以改进一下：

create profile prof2 limit password_life_time 180;
alter profile prof2 limit
PASSWORD_REUSE_MAX 5 --5次内不重用
FAILED_LOGIN_ATTEMPTS 10 --失败10次锁定
PASSWORD_LOCK_TIME 1/288 --锁定时长 5 分钟


alter user query1 profile prof2;