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

Log in with a user with administrative privileges

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

SELECT username,PROFILE FROM dba_users

2. Check the password validity settings for the specified profile (such as default):

Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'

Or: sql > SELECT * FROM dba_profiles WHERE 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

Note: there is no need to restart the database after modification, it will take effect immediately

4. Change the password

Alter user username identified by password

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.