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:

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.