In the following procedure, schema is the schema where the functions are installed
(typically PUBLIC).
- Verify that you have the privilege to grant the EXECUTE privilege on the installed functions.
-
Grant the EXECUTE privilege to either:
- Each function in schema. For
example:
GRANT EXECUTE ON FUNCTION PUBLIC.Path_Start TO PUBLIC;
- Each user for each function that he or she must run. For example:
GRANT EXECUTE ON FUNCTION PUBLIC.Path_Start TO beehive;
- Each function in schema. For
example:
-
If schema is not PUBLIC, grant each function user these additional privileges on schema:
- READ
- INSTALL
- CREATE TABLE
- TRUNCATE TABLE