REVOKE (Table)

Revokes table privileges from users and roles.

Syntax

REVOKE [ GRANT OPTION FOR ] { privilege[,…] | ALL [ PRIVILEGES ] }
   ON { 
     [ TABLE ] [[database.]schema.]table[,…] 
     | ALL TABLES IN SCHEMA [database.]schema[,…] }
   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 privileges: Important: Only SELECT privileges can be revoked on system tables. `SELECT`: Query tables of this schema. `INSERT`: Insert rows into tables of this schema, or and load data into tables with `COPY`. Note: `COPY FROM STDIN` is allowed all users with INSERT privileges, while `COPY FROM file` requires admin privileges. `UPDATE`: Update rows of tables of this schema. `DELETE`: Delete rows of tables of this schema. `REFERENCES`: Create foreign key constraints for tables of this schema. `TRUNCATE`: Truncate table contents. Non-owners of the tables can no longer execute the following partition operations on them: `DROP_PARTITIONS` `SWAP_PARTITIONS_BETWEEN_TABLES` `MOVE_PARTITIONS_TO_TABLE`
`ALL [PRIVILEGES]`	Revokes all table privileges. The optional keyword `PRIVILEGES` is supported to comply 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 One exception applies: you can specify system tables without their schema name. If you specify a database, it must be the current database.
table	The table on which to revoke privileges.
`ALL SEQUENCES IN SCHEMA schema`	Revokes privileges from all tables and views in the specified schema.
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.

Privileges

One of the following:

Superuser
Privileges grantor

Examples

Revoke user Joe's privileges on table customer_dimension.

=> REVOKE ALL PRIVILEGES ON TABLE customer_dimension FROM Joe;
REVOKE PRIVILEGE

REVOKE (Table)

Syntax

Parameters

Privileges

Examples

See Also