REVOKE (Procedure)
Revokes procedure privileges from users and roles.
Syntax
REVOKE [ GRANT OPTION FOR ] { EXECUTE | ALL PRIVILEGES } ON PROCEDURE [[database.]schema.]procedure( [argument-list] )[,…] FROM grantee[,…] [ CASCADE ]
Parameters
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. |
EXECUTE | Revokes grantees ability to run the specified procedures. |
ALL [PRIVILEGES] |
Revokes all procedure privileges that also belong to the revoker. Users cannot revoke privileges that they themselves lack. The optional keyword |
[database.]schema
|
Specifies a schema, by default 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: |
CASCADE
|
|
Privileges
Non-superuser, one of the following:
- Owner
- Privileges grantee given the option (
WITH GRANT OPTION
) of revoking privileges from other users or roles.
Examples
This example revokes user Bob
's execute privilege on the tokenize
procedure.
=> REVOKE EXECUTE ON PROCEDURE tokenize(varchar) FROM Bob;