Fragment-Level Privileges

The keyword or keywords that follow the FRAGMENT keyword specify fragment-level privileges, which are a logical subset of table-level privileges:


Fragment-Level Privileges

|--+-ALL------------+-------------------------------------------|
   | .-,----------. |   
   | V            | |   
   '---+-INSERT-+-+-'   
       +-DELETE-+       
       '-UPDATE-'

These keywords correspond to the following fragment-level privileges:

Keyword: Effect on Grantee
ALL: Receives Insert, Delete, and Update privileges on the fragment
INSERT: Can insert rows into the fragment
DELETE: Can delete rows from the fragment
UPDATE: Can update rows in the fragment and in any columns.