Script categories

Tuesday, 19 February 2013

Password expiry


When the following error occurs:

ORA-28002: the password will expire within 7 days

Two ALTER styatements are required in order for the user to stop receiving such errors when a connection is attempted:

Assume the two ALTER statement are executed as SYS:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER USERNAME IDENTIFIED BY PASSWORD;