Grant Create privilege

To grant Create administration privilege for UDXs:
  • GRANT CREATE FUNCTION TO user_or_group;
  • GRANT CREATE AGGREGATE TO user_or_group;
  • GRANT CREATE LIBRARY TO user_or_group;

If you run this command while connected to the SYSTEM database, the privilege is granted to the user in all databases. If you are connected to a specific database, the privilege is granted to the user in only that database.

Using the release 7.0.3 fully qualified name form, you could also issue the command from any database and specify an IN clause to set the privilege scope. For example, the following command grants the user Create Function privilege in all databases and schemas: 

GRANT CREATE FUNCTION IN ALL.ALL TO myuser;
The following command grants the user Create Function privilege in the database named NORTH and the schema named SALES:
GRANT CREATE FUNCTION IN NORTH.SALES TO myuser;