RSS Feed for This PostCurrent Article

Oracle: Alter Password Policy

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;


Trackback URL


Sorry, comments for this entry are closed at this time.