How to change the validity period of the Oracle Default User Password

The following article mainly describes how to correctly modify the actual operation steps of the validity period of the Oracle Default User Password. This article mainly uses the actual application code to introduce the actual operation, the following is the description of the specific content of the article. I hope you will gain some benefits after browsing it.

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

 
 


  
  
SQL> SELECT username, PROFILE FROM dba_users;

 
 

2. view the password validity period settings of the specified profile, such as default:

 
 


  
  
SQL> SELECT * FROM dba_profiles s WHERE s. profile = '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 modification, the database does not need to be restarted and takes effect immediately. Keywords: Database
 

The above content is an introduction to the validity period of modifying the Oracle Default User Password. I hope you will find some gains.