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;

See Also