The sysfragauth system catalog table stores information about the privileges that are granted on table fragments. This table has the following columns.
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 appear in the sysfragauth table. In this example, the grantee ted can grant the Update, Delete, and Insert privileges to other users.
| grantor | grantee | tabid | fragment | fragauth |
|---|---|---|---|---|
| dba | dick | 101 | dbsp1 | -ui--- |
| dba | jane | 101 | dbsp3 | --i--- |
| dba | mary | 101 | dbsp4 | --id-- |
| dba | ted | 101 | dbsp2 | -UID-- |