ON PROCEDURE

Syntax

GRANT { EXECUTE | ALL [ PRIVILEGES ] }
    ON { PROCEDURE procedure_name ( [ [ argmode ] [ arg_name ] arg_type [, ...] ] ) [, ...]
         | ALL PROCEDURES IN SCHEMA schema_name [, ...] }
    TO role_specification [, ...] [ WITH GRANT OPTION ]

Parameters

ON PROCEDURE: Grant privileges on a stored procedure.
Note: A role cannot execute a procedure unless EXECUTE is granted to the role on the procedure and USAGE or ALL PRIVILEGES is granted to the role on the owning schema.
EXECUTE: Privilege to execute (run) a procedure.
ALL PROCEDURES IN SCHEMA: Grant the privilege to all the procedures in the named schema.

Examples

Grant EXECUTE privilege on a stored procedure to the ybd user.

premdb=# grant execute on procedure proc1() to ybd;
GRANT

Grant EXECUTE privilege on all stored procedures in the public schema to the ybd user:

premdb=# grant execute on all procedures in schema public to ybd;
GRANT