REVOKE (Procedure)
Revokes the execute privilege on a procedure from a user or role.
Syntax
REVOKE EXECUTE ... ON PROCEDURE [ schema.]procedure-name[,...] ... ( [ argname ] argtype[,... ] ] ) ... FROM { PUBLIC | { username | role }[,...] } ...[ CASCADE ]
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
procedure‑name |
Specifies the procedure on which to revoke the execute privilege. |
argname |
Optionally specifies the argument names used when creating the procedure. |
argtype |
Specifies the argument types used when creating the procedure. |
PUBLIC
|
Revokes the privilege from all users. |
username |
Specifies the user from whom to revoke the privilege. |
role |
Specifies the role from whom to revoke the privilege. |
CASCADE
|
Revokes the privilege from the specified user or role and then from others. After a user or role has been granted a privilege, the user can grant that privilege to other users and roles. The CASCADE keyword first revokes the privilege from the initial user or role, and then from other grantees extended the privilege. |
Privileges
You must have DBADMIN privileges to run REVOKE (Procedure).
Examples
This example revokes Bob's execute privilege on the tokenize
procedure.
=> REVOKE EXECUTE ON PROCEDURE tokenize(varchar) FROM Bob;