Revoking Privileges Without Specifying Fragments

About this task

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 Informix® Database Design and Implementation Guide.