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;
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