Disable Oracle Password Expiry

Unlike older releases, Oracle 11g and later sets password expiry by default.

So let’s get rid of the annoyance with:

ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;

And, optionally, let’s turn off the default auditing:

NOAUDIT ALL;
DELETE FROM SYS.AUD$;

Robert Sandham