GRANT EXECUTE Statement

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

Syntax

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

Parameters

userID – must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.

Standards

SQL – syntax is a Persistent Stored Module feature.
Sybase – the security model is different in Adaptive Server Enterprise and SAP Sybase IQ, so other syntaxes differ.

Permissions

Requires one of:

MANAGE ANY OBJECT PRIVILEGE system privilege.
You own the procedure.

Parent topic: SQL Statements

Related reference

REVOKE EXECUTE Statement

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com