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

This article shows you how to change the expiration policy of oracle database password, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Query when the database user expires and log in to the database PL/SQL tool, enter the following sql statement: select username,expiry_date from dba_users where username in ('TFDS','SYSTEM'); from the above sql query, the system user expires on 2019-7-12 and the tfds user expires on 2020-1-31. two。 Query the password expiration policy of the oracle database 1) query which parameter file select username,profile from dba_users where username in ('TFDS','SYSTEM') is used by the user's password policy; from this you can see that the password parameter file is "DEFAULT" 2) query the password expiration policy days of the "DEFAULT" parameter file select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME' 3) it can be seen that the password expiration days of the "DEFAULT" parameter file is 180 days. Modify the oracle database password indefinitely 1) execute "alter profile default limit password_life_time unlimited;" 2) query whether the validity period of the database password is changed indefinitely. Select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; the above is how to modify the expiration policy of oracle database password, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.