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);
Last modified date: 08/14/2024