REVOKE EXECUTE Statement

Removes EXECUTE permissions that were given using the GRANT statement.

Syntax

REVOKE EXECUTE ON [ owner.]procedure-name 
FROM 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—Syntax is supported by Adaptive Server Enterprise. User management and security models are different for v and SAP Sybase IQ.

Permissions

You either:

Own the procedure, or
Have been granted the MANAGE ANY OBJECT PRIVILEGE system privilege.

Parent topic: SQL Statements

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