REVOKE (Database)

Revokes database privileges from users and roles.

Syntax

REVOKE [ GRANT OPTION FOR ] { privilege[,…] | ALL [ PRIVILEGES ] }
   ON DATABASE db‑spec
   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 database privilege to revoke, one of the following: `CREATE`: Create schemas. `TEMP`: Create temporary tables.
`ALL [PRIVILEGES]`	Revokes all database 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.
`ON DATABASE db‑spec`	Specifies the current database, set to the database name or `DEFAULT`.
`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.

Non-superuser, one of the following:

Owner
Privileges grantee given the option (WITH GRANT OPTION) of revoking privileges from other users or roles.

Revoke user Fred's privilege to create schemas in the current database:

=> REVOKE CREATE ON DATABASE DEFAULT FROM Fred;

Revoke user Fred's privilege to create temporary tables in the current database:

=> REVOKE TEMP ON DATABASE DEFAULT FROM Fred;