GRANT EXECUTE Statement

Grants EXECUTE privilege on a procedure or user-defined function.

Quick Links:

Go to Parameters

Go to Standards

Go to Permissions

Syntax

GRANT EXECUTE 
  ONowner.] {procedure-name | user-defined-function-name }
  TO userID [,...]

Parameters

(back to top)

Standards

(back to top)

  • SQL–syntax is a Persistent Stored Module feature.

  • SAP Sybase Database product–the security model is different in Adaptive Server and SAP Sybase IQ, so other syntaxes differ.

Permissions

(back to top)

Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You own the procedure.
Related reference
REVOKE EXECUTE Statement