Tuesday 28 April 2009

Password expiry in Oracle DB 11g

I did not pay attention to it until today, but since Oracle 11g accounts have by default a limited valid period for password. By default password expire causing a password change upon logon. This is very inconvenient for databases running as a repository for applications like for example the SoaSuite.
I found after a little googling a solution answer for example here. The solution is by simply disabling the password expiration on the default profile:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

1 comment :

Anonymous said...

I've been using multiple profiles since v8i. by creating seperate system and application profiles I can enforce password management for end users while sys/appl users have their own rules.
I appears Oracle is finally pushing people to consider something other than the old unlimited DEFAULT profile, and I think it's a good thing and way over due.