SYSFRAGAUTH
The sysfragauth system catalog table stores information
about the privileges that are granted on table fragments. This table
has the following columns.
| 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):
|
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-- |