Friday 27 July 2012

Changing password from expire to unexpire

Changing password from expire to unexpire -


CREATE PROFILE Dummy LIMIT
PASSWORD_GRACE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;

ALTER USER <username> PROFILE Dummy;
ALTER USER  <username>  IDENTIFIED BY <SAME PASSWORD>;
ALTER USER  <username>  PROFILE DEFAULT;
DROP PROFILE Dummy;

No comments:

Post a Comment