ALTER PROFILE Examples
Alter a user profile:
1. Update a default profile by using the alter default profile variant of the ALTER PROFILE statement.
ALTER DEFAULT PROFILE
WITH EXPIRE_DATE = '30 days';
2. Change the default profile to include createdb privileges.
ALTER DEFAULT PROFILE
ADD PRIVILEGES (CREATEDB);
Only one of default profile and profile profile_name can be specified.
3. Alter the trusted profile to add the createdb privilege and make the default group trusted_group:
ALTER PROFILE trusted
ADD PRIVILEGES (CREATEDB)
WITH GROUP = trusted_group
All users currently using this profile have the appropriate changes made to their security privilege and group.
4. Alter the security auditing for profile, clerk.
ALTER PROFILE clerk
WITH SECURITY_AUDIT = (QUERY_TEXT, DEFAULT_EVENTS);