REVOKE FRAGMENT statement

Use the REVOKE FRAGMENT statement to revoke from one or more users or roles the Insert, Update, or Delete fragment-level privileges that were granted on individual fragments of a table that has been fragmented by expression. This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

Notes:

¹ See Fragment-Level Privileges


Element	Description	Restrictions	Syntax
`fragment`	Name of a fragment or the dbspace that stores one fragment. Default is all fragments of `table`.	Must exist and must store a fragment of table	Identifier
`revoker`	User (who is not executing this statement) who was grantor of privileges to be revoked	Must be grantor of the fragment-level privileges	Owner name
`role`	Role from which privileges are to be revoked	Must exist in the database	Owner name
`table`	Fragmented table whose fragment-level privileges are to be revoked	Must exist and must be fragmented by expression	Database Object Name
`user`	User from whom privileges are to be revoked	Must be a valid authorization identifier	Owner name

Usage

The REVOKE FRAGMENT statement is a special case of the REVOKE statement for assigning privileges on table fragments. Use the REVOKE FRAGMENT statement to revoke the Insert, Update, or Delete privilege on one or more table fragments from one or more users or roles. The DBA can use this statement to revoke privileges on a fragment whose owner is another user.

The REVOKE FRAGMENT statement is valid only for tables that are fragmented by an expression-based distribution scheme. For an explanation of this fragmentation strategy, see Expression Distribution Scheme.