REVOKE EXECUTE Statement
Removes EXECUTE permissions that were given using the GRANT statement.
Syntax
REVOKE EXECUTE ON [ <owner>.]<procedure-name> FROM <userID> [,...]
Parameters
- 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.
-
SAP Database products—Syntax is supported by SAP ASE. User management and security models are different for SAP ASE and SAP IQ.