REVOKE (View)

Revokes privileges on a view from users and roles.

Syntax

REVOKE [ GRANT OPTION FOR ] { privilege[,…] | ALL [ PRIVILEGES ] }
   ON [[database.]schema.]view[,…] 
   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: SELECT: Query the specified views. `ALL [PRIVILEGES]`: Revokes all privileges that pertain to views that also belong to the grantor. Grantors cannot revoke privileges that they themselves lack. 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.
view	The view on which to revoke privileges.
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.

Revoke SELECT privileges from user Joe on view test_view.

=> REVOKE SELECT ON test_view FROM Joe;
REVOKE PRIVILEGE