Revoking Privileges on More Than One Fragment
The following statement revokes all privileges currently granted to user millie on the fragments of the customer table in part1 and part2:
REVOKE FRAGMENT ALL ON customer (part1, part2) FROM millie;