ORACLE 11G PASSWORD EXPIRATION

Oracle 11g

In Oracle 11g release, schema password is expired periodically, by default this is 180 days. However, if required we can alter this setting and make the password permanent. This change needs to be done to the profile of the schema, all schemas under this profile is affected.

select PROFILE from dba_users where username = ëUser you are interested iní;

ALTER PROFILE PASSWORD_LIFE_TIME UNLIMITED;

Leave a Reply

Your email address will not be published. Required fields are marked *