Shulou(Shulou.com)05/31 Report--

This article mainly explains the "Oracle data user password expiration processing method is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "Oracle data user password expiration processing method is what" it!

If profile is not specified in Oracle database, the default profile used by users is DEFAULT, and the default profile specifies that each user's password is valid for 180 days. The query method is as follows:

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

PS: if the user has configured profile for the specified custom configuration in the database, change the DEFAULT to the specified name.

If you use the default profile:DEFAULT after the database is online, if you do not reset the user password after more than 180 days of running the database, you will make an error in linking to the database user Times: ORA-28002. At this point, you can reset the password or set the user password to a load that does not expire.

Oracle database user password never expires setting method:

The following steps are used for user actions with DBA privileges

1. View the profile files of users with invalid passwords

SQL > SELECT username,profile FROM dba_users

two。 View the password validity settings for the corresponding profile

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

3. Change the default value of password validity 180 days to "unlimited"

SQL > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

The parameter modification takes effect in real time.

Note:

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

Users who have expired before changing the PASSWORD_LIFE_ time value still need to change their password again before they can use it.

SQL > alter user user_name identified by password

Query the account_status field of dba_users, which has the following values

ACCOUNT_STATUS

OPEN

EXPIRED-this status indicates that it has expired

EXPIRED (GRACE)

LOCKED (TIMED)

LOCKED

EXPIRED & LOCKED (TIMED)

EXPIRED (GRACE) & LOCKED (TIMED)

EXPIRED & LOCKED

EXPIRED (GRACE) & LOCKED

Thank you for your reading, the above is the "Oracle data user password expiration processing method is what" the content, after the study of this article, I believe you on Oracle data user password expiration processing method is what this problem has a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.