REVOKE FRAGMENT

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.

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

                                                  (1)
>>-REVOKE FRAGMENT--| Fragment-Level Privileges |--------------->
 
>--ON--table--+--------------------+--FROM---------------------->
              |    .-,--------.    |
              |    V          |    |
              '-(----fragment-+--)-'
 
>--+-PUBLIC---------+--+-------------------+-------------------><
   | .-,----------. |  '-AS--+-revoker---+-'
   | V            | |        '-'revoker'-'
   '---+-user---+-+-'
       +-'user'-+
       +-role---+
       '-'role'-'

Notes:

See Fragment-Level Privileges

Element	Description	Restrictions	Syntax
fragment	Name of partition or 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 whom 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.