In Oracle11g, in order to allow the customer to change the password of the database user within six months, the default password of the database user is valid for 180 days by default, while Oracle10g is
In Oracle 11g, to allow the customer to change the Database User Password within half a year, the default password of the database user is valid for 180 days by default, while the Oracle 10g is
In Oracle 11g, to allow the customer to change the Database User Password within six months, the default password of the database user is valid for 180 days by default, oracle 10 Gb default database user password is no time.
View the password parameter file used by the default database user of Oracle 11g
-- 1
SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME ';
-- Expiration on the seventh day
Change Password to no time
-- 2
Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;