REVOKE Procedure Permission

Permissions relating to SQL procedures can be revoked from users or roles.

REVOKE Procedure Permission Syntax

REVOKE EXECUTE [PRIVILEGES]
ON <ALL PROCEDURES [IN [SCHEMA] <schema reference>] | PROCEDURE <procedure reference>>
FROM <user name | role name>

REVOKE Create Procedure Permission Syntax

REVOKE CREATE [PRIVILEGES] ON PROCEDURES
[IN [SCHEMA] <schema reference>]
FROM <user name | role name>

Examples

To revoke execute on the sqlp_weekly procedure from spuser:

REVOKE EXECUTE PROCEDURE Permission Example

REVOKE EXECUTE PROCEDURE ON example.sqlp_weekly FROM spuser