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 ]
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. |
privilege |
One of the following:
|
ALL PRIVILEGES |
Revokes all privileges that pertain to views 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. |
view |
The view on which to revoke privileges. |
grantee | Specifies whose privileges are revoked, one of the following: |
CASCADE |
|
Examples
Revoke SELECT privileges from user Joe
on view test_view
.
=> REVOKE SELECT ON test_view FROM Joe; REVOKE PRIVILEGE