The TO Clause

The list of one or more users or roles that follows the TO keyword identifies the grantees. You can specify the PUBLIC keyword to grant the specified fragment-level privileges to all users.

You cannot use GRANT FRAGMENT to grant fragment-level privileges to yourself, either directly or through roles.

If you enclose user or role in quotation marks, the name is case sensitive and is stored exactly as you typed it. In an ANSI-compliant database, if you do not use quotation marks around user or around role, the name is stored in uppercase letters.

The following statement grants the Insert, Update, and Delete privileges on the fragment of the customer table in part1 to user larry:

GRANT FRAGMENT ALL ON customer (part1) TO larry;

The following statement grants the Insert, Update, and Delete privileges on the fragments of the customer table in part1 and part2 to user millie:

GRANT FRAGMENT ALL ON customer (part1, part2) TO millie;

To grant privileges on all fragments of a table to the same user or users, you can use the GRANT statement instead of the GRANT FRAGMENT statement. You can also use the GRANT FRAGMENT statement for this purpose.

Assume that the customer table is fragmented by expression into three fragments, and these fragments reside in the dbspaces named part1, part2, and part3. You can use either of the following statements to grant the Insert privilege on all fragments of the table to user helen:

GRANT FRAGMENT INSERT ON customer (part1, part2, part3) TO helen;

GRANT INSERT ON customer TO helen;