Oracle Password Policy Management

After successful oracle installation, a default password is omitted, such as the user's password validity period and locking policy ..., by default, the oracle user password is valid for 180 days. The maximum number of failed logon attempts is 10 and the password is locked.

 

650) this. width = 650; "title =" 1.jpg" src = "http://www.bkjia.com/uploads/allimg/131229/21532B0b-0.jpg" width = "535" height = "307"/>

If you want to set the password validity period to be valid, and you can try to log on unlimited times, you need to modify the Default policy.

 

View the default password Validity Period Policy of oracle for 180 days)

SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

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

Set the oracle default policy to permanently valid

SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

View again

SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

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

View the oracle default password lock Policy

SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'failed _ LOGIN_ATTEMPTS ';

PROFILE RESOURCE_NAME RESOURCE
----------------------------------------------------------------------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD

Set to countless times

 

SQL> Alter PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

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_ATTEMPTS PASSWORD
UNLIMITED

SQL> commit
2;

Commit complete.

 

This article is from the "magic network" blog, please be sure to keep this source http://wxlxiao5.blog.51cto.com/4284565/1294286