Privileges for user-defined aggregates

No privileges are directly associated with user-defined or user-extended aggregates. Instead, you must set the correct privileges for the functions that support the aggregates.

To create a function, you must have RESOURCE or DBA database-level privileges. When you create a function in a database that is not ANSI compliant, any user can use the function. When you create a function in an ANSI-compliant database, you must explicitly grant the Execute privilege on that function, so that users can use the function and thus the related aggregate.

For more information about privileges, refer to the GRANT statement in the HCL OneDB™ Guide to SQL: Syntax.