REVOKE (Resource Pool)
Revokes a user's or role's access privilege to a resource pool.
Syntax
REVOKE USAGE... ON RESOURCE POOL resource-pool ... FROM { username | PUBLIC | role } [ , ... ] ...[ CASCADE ]
Parameters
resource-pool |
Specifies the resource pool from which to revoke the usage privilege. |
username |
Revokes the privilege from the specified user. |
PUBLIC |
Revokes the privilege from all users. |
role |
Revokes the privilege from the specified role. |
CASCADE |
Revokes the privilege from the specified user or role and then from others. After a user or role has been granted a privilege, the user can grant that privilege to other users and roles. The CASCADE keyword first revokes the privilege from the initial user or role, and then from other grantees extended the privilege. |
Notes
- Vertica checks privileges on resource pools during runtime. If the user running a query does not have the USAGE privilege on the appropriate pool, the query fails with an error. In this case, the user can use ALTER USER ... RESOURCE POOL to access another resource pool. Note the user may need to be granted usage on the resource pool with GRANT USAGE ON RESOURCE POOL.
- Revoking a user's permission from a resource pool in another session affects the user's access current session. In this case, the current session fails with an error stating that the resource pool in the current session does not exist.
Examples
This example shows how to revoke user Joe's usage privilege on the Joe_pool resource pool.
=> REVOKE USAGE ON RESOURCE POOL Joe_pool FROM Joe; REVOKE PRIVILEGE