As development demands, we would like to turn off Orace User Password Never Expired function.
Check the current profile's password life time:
SQL> select * from dba_profiles where profile='PROFILE' and RESOURCE_NAME='PASSWORD_LIFE_TIME';
we need to change the limit of password_life_time parameter to unlimited.
SQL> alter profile PROFILE limit PASSWORD_LIFE_TIME unlimited;
then all the users' password will never be expired.
No comments:
Post a Comment