Wednesday, January 18, 2012

How to disable Oracle's password expiry?


 In the  Oracle 11g sets password expiry by default. To get rid of it, do the following...

Execute the following command as SYS or SYSTEM

ALTER PROFILE DEFAULT LIMIT
  FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;

No comments:

Post a Comment