Monday, April 16, 2018

Oracle DB user with password no expiry

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

  1.   by creating a new profile with LIMIT password no expired and 
  2.   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: