Manage Alter privilege

To grant or revoke Alter privileges on an object:

• GRANT ALTER ON object TO entity;
• REVOKE ALTER ON object FROM entity;

Always specify a complete signature for the object value. For example, to grant Alter privileges for the sample function CustomerName to the user myuser:

GRANT ALTER ON CustomerName(varchar(64000)) TO myuser;

To grant Alter privilege on all aggregates to the user newuser:

GRANT ALTER ON AGGREGATE TO newuser;

To revoke Alter privileges on the CustomerName function from the group sales:

REVOKE ALTER ON CustomerName(varchar(64000)) FROM GROUP sales;