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

(explicit id refr002) refr002 REVOKE FRAGMENT <Fragment-Level Privileges>[] ONtable [ ( fragment ) ] FROM { PUBLIC | { | user | 'user' | role | 'role' } } [ AS { revoker | 'revoker' } ]
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.

1 See Fragment-Level Privileges