External Procedure Privileges
Only a superuser is allowed to create or drop an external procedure.
By default, users cannot execute external procedures. A superuser must grant users and roles this right, using the GRANT (Procedure) EXECUTE statement. Additionally, users must have USAGE privileges on the schema that contains the procedure in order to call it.
Privilege | Description |
---|---|
EXECUTE |
Permission to run an external procedure. |
USAGE |
Permission on the schema that contains the procedure. |
For details on granting and revoking external table privileges, see GRANT (Procedure) and REVOKE (Procedure) in the SQL Reference Manual.