Usually in default user profile, password expires for a user after certain period. If we want that password won't expire for a user as it may be required for the users used in the application end, we can implement that
- by creating a new profile with LIMIT password no expired and
- assigning this profile to our target users.
create profile pro_pass_no_exp limit password_life_time UNLIMITED;
Profile created.
alter user dbbl profile pro_pass_no_exp;
User altered.
No comments:
Post a Comment