Revoking Privileges Without Specifying Fragments
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
Related statements: GRANT FRAGMENT statement and REVOKE statement
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.