Revoking Privileges on One Fragment
About this task
The following statement revokes the Update privilege
on the fragment of the customer table in part1 from
user ed:
REVOKE FRAGMENT UPDATE ON customer (part1) FROM ed;
The
following statement revokes the Update and Insert privileges on the
fragment of the customer table in part1 from user susan:
REVOKE FRAGMENT UPDATE, INSERT ON customer (part1) FROM susan;
The
following statement revokes all privileges currently granted to user harry on
the fragment of the customer table in part1:
REVOKE FRAGMENT ALL ON customer (part1) FROM harry;