ALTER PROFILE
Purpose
Use the ALTER
PROFILE
statement to add, modify, or remove a resource limit or password management parameter in a profile.
Changes made to a profile with an ALTER
PROFILE
statement affect users only in their subsequent sessions, not in their current sessions.
See Also:
CREATE PROFILE for information on creating a profilePrerequisites
You must have ALTER
PROFILE
system privilege to change profile resource limits. To modify password limits and protection, you must have ALTER
PROFILE
and ALTER
USER
system privileges.
Syntax
alter_profile::=