WITH GRANT OPTION Clause
As in other GRANT statements, the WITH GRANT OPTION keywords specify that the grantee can grant the same fragment-level privileges to other users. WITH GRANT OPTION is not valid if the TO clause specifies a role as grantee. For additional information, see WITH GRANT OPTION keywords.
The following statement grants the Update privilege on
the fragment of the customer table in part3 to user george and
also gives george the right to grant the Update privilege on the same
fragment to other users:
GRANT FRAGMENT UPDATE ON customer (part3) TO george WITH GRANT OPTION;