Changes made to a profile with an
PROFILE statement affect users only in their subsequent sessions, not in their current sessions.
See Also:CREATE PROFILE for information on creating a profile
You must have the
PROFILE system privilege.
To specify the
CONTAINER clause, you must be connected to a multitenant container database (CDB). To specify
ALL, the current container must be the root. To specify
CURRENT, the current container must be a pluggable database (PDB).
The keywords, parameters, and clauses in the
PROFILE statement all have the same meaning as in the
You cannot remove a limit from the
Refer to CREATE PROFILE and to the examples in the next section for more information.
Making a Password Unavailable: Example The following statement makes the password of the
new_profile profile (created in "Creating a Profile: Example") unavailable for reuse for 90 days:
ALTER PROFILE new_profile LIMIT PASSWORD_REUSE_TIME 90 PASSWORD_REUSE_MAX UNLIMITED;
Setting Default Password Values: Example The following statement defaults the
PASSWORD_REUSE_TIME value of the
app_user profile (created in "Setting Profile Resource Limits: Example") to its defined value in the
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;
This statement causes any user account to which the
app_user profile is assigned to become locked for one day after five consecutive unsuccessful login attempts.
ALTER PROFILE app_user2 LIMIT PASSWORD_LIFE_TIME 90 PASSWORD_GRACE_TIME 5;
ALTER PROFILE app_user LIMIT SESSIONS_PER_USER 5;
app_user profile does not currently define a limit for
SESSIONS_PER_USER, then the preceding statement adds the limit of 5 to the profile. If the profile already defines a limit, then the preceding statement redefines it to 5. Any user assigned the
app_user profile is subsequently limited to 5 concurrent sessions.
ALTER PROFILE app_user LIMIT IDLE_TIME DEFAULT;
Any user assigned the
app_user profile is subject in their subsequent sessions to the
IDLE_TIME limit defined in the
ALTER PROFILE default LIMIT IDLE_TIME 2;
IDLE_TIME limit applies to these users:
Users who are not explicitly assigned any profile
Users who are explicitly assigned a profile that does not define an
This statement defines unlimited idle time for the
ALTER PROFILE app_user2 LIMIT IDLE_TIME UNLIMITED;
Any user assigned the
app_user2 profile is subsequently permitted unlimited idle time.