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.

One of the following privileges:

• SELECT: Query tables. SELECT privileges are granted by default to the PUBLIC role.
• INSERT: Insert rows, or and load data into tables with COPY.

  COPY FROM STDIN is allowed for users with INSERT privileges, while COPY FROM file requires admin privileges.

• UPDATE: Update table rows.
• DELETE: Delete table rows.
• REFERENCES: Create foreign key constraints on this table. This privilege must be set on both referencing and referenced tables.
• TRUNCATE: Truncate table contents. Non-owners of tables can also execute the following partition operations on them:
  • DROP_PARTITIONS
  • SWAP_PARTITIONS_BETWEEN_TABLES
  • MOVE_PARTITIONS_TO_TABLE
• ALTER: Modify a table's DDL with ALTER TABLE.
• DROP: Drop a table.

Revokes all table privileges that also belong to the revoker. Users cannot revoke privileges that they themselves lack.

The optional keyword PRIVILEGES is supported to comply with the SQL standard.

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.

Specifies the table on which to revoke privileges.

Revokes the specified privileges on all tables and views in schema schema.

• User name
• Role
• PUBLIC: The default role of all users

If 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.