top of page
CerebroSQL

Oracle:

ALTER PROFILE

ALTER PROFILE profile LIMIT
{ resource_parameters | password_parameters } ...
;

Example

ALTER PROFILE new_profile
LIMIT PASSWORD_REUSE_TIME 90
PASSWORD_REUSE_MAX UNLIMITED;
ALTER PROFILE app_user
LIMIT PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX UNLIMITED;
ALTER PROFILE app_user LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 1;
ALTER PROFILE app_user2 LIMIT
PASSWORD_LIFE_TIME 90
PASSWORD_GRACE_TIME 5;
ALTER PROFILE app_user LIMIT SESSIONS_PER_USER 5;
ALTER PROFILE app_user LIMIT IDLE_TIME DEFAULT;
ALTER PROFILE default LIMIT IDLE_TIME 2;
ALTER PROFILE app_user2 LIMIT IDLE_TIME UNLIMITED;

bottom of page