Granting Privileges to One User or a List of Users

About this task

You can grant fragment-level privileges to a single user or to a list of users.

The following statement grants the Insert, Update, and Delete privileges on the fragment of the customer table in part3 to user oswald:
GRANT FRAGMENT ALL ON customer (part3) TO oswald;
The following statement grants the Insert, Update, and Delete privileges on the fragment of the customer table in part3 to users jerome and hilda:
GRANT FRAGMENT ALL ON customer (part3) TO jerome, hilda;