Which grant is used to authorize the execution of a procedure?

To grant permissions to execute a stored procedure in most DBMSs, the GRANT EXECUTE command is used.

For example, in PostgreSQL or Oracle:

GRANT EXECUTE ON PROCEDURE procedure_name TO user_name;

In some DBMSs, it is possible to grant rights to an entire package of procedures or to a schema as a whole.

This allows restricting access to executing the procedure to specific users or roles, ensuring security and access control.