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>');
