Granting One Privilege or a List of Privileges
About this task
When you specify fragment-level privileges in a GRANT FRAGMENT statement, you can specify one privilege, a list of privileges, or all privileges.
The following statement grants the Update
privilege on the fragment of the customer table in part1 to
user ed:
GRANT FRAGMENT UPDATE ON customer (part1) TO ed;
The
following statement grants the Update and Insert privileges on the
fragment of the customer table in part1 to user susan:
GRANT FRAGMENT UPDATE, INSERT ON customer (part1) TO susan;
The
following statement grants the Insert, Update, and Delete privileges
on the fragment of the customer table in part1 to user harry:
GRANT FRAGMENT ALL ON customer (part1) TO harry;