SQL Language Guide : 8. SQL Statements : ALTER PROFILE : ALTER PROFILE Examples
 
Share this page                  
ALTER PROFILE Examples
The following 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.