Tuesday, September 3, 2013

How to make user password "unexpired" in Oracle Database

The common problem with development FMW instances is expiring passwords of FMW database users  like DEV_MDS, etc.

To change default password expiration policy for all users you should run:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;


To "unexpire" expired password:

ALTER USER scott IDENTIFIED BY password;

No comments:

Post a Comment