This content has been marked as final. Show 2 replies
Your SQL is ok. Check with these two parameters will show you the time when user password will expire. Check the profile values when a password will expire. If you assign user A,B.C to a profile which password will expire after 1o days then password of A,B,C will be expired after 10 days.
Replace scott with user you are interested in , if it is unlimited or no rows selected it means it wont expire.
How can I check if user password will not expire ? select LIMIT from dba_profiles where RESOURCE_NAME ='FAILED_LOGIN_ATTEMPTS' and PROFILE = (select profile from dba_users where username = 'SCOTT');
How can I check if stupid default password expire option is turned off ? same as above
How can I check when user password will expire ? same as above
How can I disable passsword expiration for specified user ? select profile from dba_users where username = 'User you are interested in'; ALTER PROFILE <name of the profile from above query> LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED