|Oracle® Database SQL Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
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
PROFILE system privilege to change profile resource limits. To modify password limits and protection, you must have
USER system privileges.
The keywords, parameters, and clauses in the
PROFILE statement all have the same meaning as in the
You cannot remove a limit from the
Please 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 the
app_user account to become locked for one day after five 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, the preceding statement adds the limit of 5 to the profile. If the profile already defines a limit, 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.