Pages

Monday, June 3, 2013

Oracle User Password Never Expired

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: