REVOKE (Resource Pool)
Revokes resource pool access privileges from users and roles.
Vertica checks resource pool privileges at runtime. Revoking a user's privileges for a resource pool can have an immediate effect on the user's current session. For example, a user query might require USAGE privileges on a resource pool. If you revoke those privileges from that user, subsequent attempts by the user to execute that query fail and return with an error message.
Syntax
REVOKE [ GRANT OPTION FOR ] { USAGE | ALL PRIVILEGES } ON RESOURCE POOL resource-pool[,...] [FOR SUBCLUSTER subcluster | FOR CURRENT SUBCLUSTER] 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
|
Revokes grantee's access to the specified resource pool. |
ALL PRIVILEGES
|
Revokes all resource pool privileges that also belong to the revoker. Users cannot revoke privileges that they themselves lack. The optional keyword |
resource-pool
|
The target resource pool. |
subcluster
|
The subcluster for the resource pool. |
grantee
|
Specifies whose privileges are revoked, one of the following: |
CASCADE
|
|
Privileges
Non-superuser, one of the following:
- Ownership
- GRANT OPTION on the object
Examples
Revoke user Joe
's USAGE privileges on resource pool Joe_pool
.
=> REVOKE USAGE ON RESOURCE POOL Joe_pool FROM Joe; REVOKE PRIVILEGE
Revoke user Joe
's USAGE privileges on resource pool Joe_pool
for subcluster sub1
.
=> REVOKE USAGE ON RESOURCE POOL Joe_pool FOR SUBCLUSTER sub1 FROM Joe; REVOKE PRIVILEGE