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

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

See Also