REVOKE (Model)
Revokes model privileges from users and roles.
Syntax
REVOKE [ GRANT OPTION FOR ] { privilege[,…] | ALL [ PRIVILEGES ] } ON MODEL [[database.]schema.]model‑name [,…] 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. |
USAGE |
One of the following privileges: |
ALL [PRIVILEGES] |
Revokes all model privileges 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. |
model‑name |
Name of the target model. |
grantee
|
Specifies whose privileges are revoked, one of the following: |
CASCADE |
|
Privileges
Non-superuser, one of the following:
- Owner
- Privileges grantee given the option (
WITH GRANT OPTION
) of revoking privileges from other users or roles.
Example
Revoke user Fred
's USAGE privilege on model mySvmClassModel
:
=> REVOKE USAGE ON mySvmClassModel FROM Fred;
See Also