The following statement revokes all current privileges from user mel on all fragments for which this user currently has privileges:
REVOKE FRAGMENT ALL ON customer FROM mel
Related statements: GRANT FRAGMENT and REVOKE
For a discussion of fragment-level and table-level privileges, see the section Fragment-Level Privileges. See also the IBM Informix Database Design and Implementation Guide.