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;
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:
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:
Subscribe to:
Post Comments
(
Atom
)
1 comment :
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.
Post a Comment