Shulou(Shulou.com)06/01 Report--

Http://www.cnblogs.com/tippoint/archive/2013/03/08/2950126.html

Changing the oracle user password never expires:

1. Check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

2. Check the password validity settings for the specified profile (such as default):

Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'

3. Change the password validity period from the default 180 days to "unlimited":

Sql > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

After the modification, there is no need to restart the database, it will take effect immediately.

4. After modification, accounts that have not been prompted for ORA-28002 warning will not encounter the same prompt again.

Accounts that have been prompted must change their passwords again, for example: Zhonghua examination website

$sqlplus / as sysdba

Sql > alter user smsc identified by-there is no need to change a new password

Http://www.linuxidc.com/Linux/2014-10/107853.htm

1. Check the value of FAILED_LOGIN_ATTEMPTS

Select * from dba_profiles

2. Modify it to 30 times alter profile default limit FAILED_LOGIN_ATTEMPTS 30

3. Modify it to unlimited number of times (for security reasons, it is not recommended) alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited

User unlocks:

Alter user user_name account unlock

Oracle password expiration setting:

The default password expiration limit for Oracle 11G when creating a user is 180 days, and if the user's password is not changed for more than 180 days, the user cannot log in.

Can be passed through

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

Statement to query the password validity setting, and the LIMIT field is the number of days the password is valid.

When the password is about to expire or has expired, you can use:

ALTER USER username IDENTIFIED BY password

Statement to change the password, after the password is changed, the user can connect to the database normally.

Long-term correspondence can be achieved by:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

Statement changes the default value of the password validity period of 180 days to "unlimited".

For the sake of database security, it is not recommended to set the PASSWORD_LIFE_ time value to UNLIMITED, and customers are advised to change the database user password on a regular basis.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.