Oracle Database Password Management: Resetting Password Policies and User Account Expiry Issues

 

Checking Password Lifetime Policy

Oracle password expiration rules are controlled through profiles. The following query helps identify the configured password lifetime:

SELECT profile, resource_name, limit
FROM dba_profiles
WHERE resource_name = 'PASSWORD_LIFE_TIME';

Reviewing Password Reuse Settings
Password reuse restrictions can be checked using:
SELECT resource_name, limit
FROM dba_profiles
WHERE profile = 'DEFAULT'
AND resource_name LIKE 'PASSWORD_REUSE%';

Modifying Password Reuse Policy
If required by organizational policy, the password reuse limit can be adjusted:
ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;
After making the required changes, ensure the profile settings align with your organization's security standards.

Checking User Account Expiry
Database administrators can review account expiry information using:
SELECT username, expiry_date
FROM dba_users
WHERE username IN ('<USER_NAME>');