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

This article mainly explains "what to do when the password of oracle database expires". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "what to do when the oracle database password expires"!

SELECT username,profile FROM dba_users; / / check where the password expired file is saved

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME' / / View password expiration time settings

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; / / modify the expiration time to infinite

Alter user htetm4 identified by htetm4; / / change the password that has expired

At this point, I believe that everyone on the "oracle database password expiration how to do" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.