Oracle: Alter Password Policy
By admin on Aug 4, 2008 in Oracle
Whenever an Oracle user is created, the default profile is DEFAULT is none is specified. To set the login attempts to unlimited, run the following to change the DEFAULT profile.
alter profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Make the password unavailable for 90 days
ALTER PROFILE new_profile
LIMIT PASSWORD_REUSE_TIME 90
PASSWORD_REUSE_MAX UNLIMITED;
Set default password values
ALTER PROFILE app_user
LIMIT PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX UNLIMITED;
Limited login attempts and password lock time
ALTER PROFILE app_user LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 1;
Limited concurrent sessions
ALTER PROFILE app_user LIMIT SESSIONS_PER_USER 5;
Removing profile limits
ALTER PROFILE app_user LIMIT IDLE_TIME DEFAULT;
Changing password lifetime and grace period
ALTER PROFILE app_user2 LIMIT
PASSWORD_LIFE_TIME 90
PASSWORD_GRACE_TIME 5;
