REVOKE (Schema)

Revokes schema privileges from users and roles.

Syntax

REVOKE [ GRANT OPTION FOR ] { privilege[,…] | ALL [ PRIVILEGES ] }
   ON SCHEMA [database.]schema[,…]
   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	The schema privilege to revoke, one of the following: `USAGE`: Enables access to objects in the specified schemas. . `CREATE`: Create tables and views. `SELECT`: Query tables of this schema. `INSERT`: Insert rows into tables of this schema, or and load data into tables with COPY. `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. This privilege must be set on both referencing and referenced tables. `TRUNCATE`: Truncate table contents.
`ALL [PRIVILEGES]`	Revokes all schema privileges. The optional keyword `PRIVILEGES` conforms with the SQL standard.
`[database.]schema`	The schema on which to revoke privileges. If you specify a database, it must be the current database.
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.

One of the following:

Revoke user Joe's usage privileges on schema online_sales.

=> REVOKE USAGE ON SCHEMA online_sales FROM Joe;
REVOKE PRIVILEGE