Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, February 22, 2012

Disable Oracle's password expiry (11g)

 Unlike older releases, Oracle 11g sets password expiry by default. That's really annoying

  • for SYS and SYSTEM: nobody wants to regularly change (and forget) them.
  • for any accounts that are used by application servers: the password is usually configured in a data source file, nobody would ever want to change it
  • if some superusers directly access the DB and keep forgetting the password, the automatic locking will lock your application out: not great for your up time.
So let's get rid of these annoyances with:
ALTER PROFILE DEFAULT LIMIT
  FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;
And also let's turn off the default auditing:
NOAUDIT ALL;
DELETE FROM SYS.AUD$;

No comments: