Grant All privileges

To grant users or a group with all object privileges (Alter, Drop, Execute, and List) for UDXs:

• GRANT ALL ON FUNCTION TO entity;
• GRANT ALL ON AGGREGATE TO entity;
• GRANT ALL ON LIBRARY TO entity;

The following command grants all privileges for aggregate objects to the group analysts, and is scoped to the database (and schema, if applicable) in which you run the command::

GRANT ALL ON AGGREGATE TO analysts;