Oracle密码策略基本设置

Oracle密码策略基本设置

系统用的用户密码默认是180天，到期后提醒需要修改密码否则过期。
主要系统用户：OUTLN、SYSMAN、SYSTEM、SYS、MGMT_VIEW、DBSNMP
比较麻烦，调整密码策略，有效期不限期限，尝试密码次数10：

（1）修改用户密码有效期限

SQL>  --查询当前密码策略有效期限
SQL>  Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------------- ----------------------------------------
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD      180

Executed in 0.373 seconds

SQL>  --修改为不限期限
SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered


Executed in 0.285 seconds

SQL>  --已经修改为不限期限
SQL>  Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------------- ----------------------------------------
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD      UNLIMITED

Executed in 0.068 seconds

（2）修改密码尝试次数

SQL> --查询密码尝试次数，当前是不限次数
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------------- ----------------------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD      UNLIMITED

Executed in 0.104 seconds

SQL> --修改为尝试次数为10，超出锁死账号
SQL> Alter PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS  10;

Profile altered


Executed in 0.048 seconds

SQL> --密码尝试已经修改次数为10
SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- ------------- ----------------------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD      10

Executed in 0.034 seconds