Resolve oracle user expiration problem

Recently, the staff of the testing department found a problem, saying that the password prompt for oracle users is about to expire. Ask me what's going on.

After investigation found that the creation of oracle user passwords are only valid for 180 days, communicate with the relevant responsible person, decided to change the user password will never expire.

Solution:

The first method: log in with a user with DBA authority

1. Check the user's profile. By default, the profile of all users is default.

Select t.username,t.profile from dba_users t

2. Check the default profile validity period of users.

Select t.limit from dba_profiles t where t.profiledestroy DEFAULT 'and t. Resourceful nameplates PASSWORDLIFERETIME'

3. Change the validity period of all users

Alter profile default limit password_life_time unlimited

The following unlimited can be a numeric unit for days.

4. Verification

Select username,expiry_date from dba_users

The value of the expiry_date entry in the query results should be empty: indicates that the user's password never expires.

The second method: create a profile and apply it to a user

1. Create a profile

Create profile profile_name limite password_life_time unlimited

2. Apply to users

Alter user user_name profile profile_name

Create user user_name identified by password profile profile_name