REVOKE (Procedure)

Revokes procedure privileges from users and roles.

Syntax

REVOKE [ GRANT OPTION FOR ] privilege
   ON PROCEDURE [[database.]schema.]procedure( [argument-list] )[,…]
   FROM grantee[,…]
   [ CASCADE ]

`GRANT OPTION FOR`	Revokes the grant option for the specified privileges. Current privileges for grantees remain unaffected. If you omit this clause, Vertica revokes both the grant option and current privileges.
privilege	One of the following: EXECUTE `ALL [PRIVILEGES]`: Revokes all procedure privileges. The optional keyword `PRIVILEGES` conforms with the SQL standard.
`[database.]schema`	Specifies a schema, by default `public`. If schema is any schema other than `public`, you must supply the schema name. For example: myschema.thisDbObject If you specify a database, it must be the current database.
`procedure`	The target procedure.
argument-list	A comma-delimited list of procedure arguments, where each argument is specified as follows: [argname] argtype If the procedure is defined with no arguments, supply an empty argument list.
`grantee`	Specifies whose privileges are revoked, one of the following: User name Role `PUBLIC`: The default role of all users
`CASCADE`	`I`f the target grantees have a grant option to extend the specified privileges to other users, `CASCADE` specifies to search for these users and revoke the privileges from them also.

One of the following:

This example revokes user Bob's execute privilege on the tokenize procedure.

=> REVOKE EXECUTE ON PROCEDURE tokenize(varchar) FROM Bob;