The sysfragauth system catalog table stores information about the privileges that are granted on table fragments. This table has the following columns.
Table 1. SYSFRAGAUTH table column descriptions

Column Type Explanation
grantor CHAR(32) Name of the grantor of privilege
grantee CHAR(32) Name of the grantee of privilege
tabid INTEGER Identifying code of the fragmented table
fragment VARCHAR(128) Name of dbspace where fragment is stored
fragauth CHAR(6) A 6-byte pattern specifying fragment privileges (including 3 bytes reserved for future use):
  • u or U = Update
  • i or I = Insert
  • d or D = Delete

In the fragauth column, an uppercase code (such as U for Update) means that the grantee can grant the privilege to other users; a lowercase (for example, u for Update) means the user cannot grant the privilege to others. Hyphen ( - ) indicates the absence of the privilege for that position within the pattern.

A composite index on the tabid, grantor, grantee, and fragment columns allows only unique values. A composite index on the tabid and grantee columns allows duplicate values.

The following example displays the fragment-level privileges for one base table, as they exist in the sysfragauth table. In this example, the grantee rajesh can grant the Update, Delete, and Insert privileges to other users.
grantor grantee tabid fragment fragauth
dba omar 101 dbsp1 -ui---
dba jane 101 dbsp3 --i---
dba maria 101 dbsp4 --id--
dba rajesh 101 dbsp2 -UID--