When a REVOKE statement is executed, an exclusive row lock is placed on the entry in the systables system catalog table for the table from which privileges were revoked. This lock is released only after the transaction that contains the REVOKE statement is complete. When another transaction attempts to prepare a SELECT statement against this table, the transaction fails because the entry for this table in systables is exclusively locked. The attempt to prepare the SELECT statement will not succeed until the first transaction was committed.
Related Statements: GRANT, GRANT FRAGMENT, and REVOKE FRAGMENT
For information about roles, see the following statements: CREATE ROLE, DROP ROLE, and SET ROLE.
In the Informix Guide to Database Design and Implementation, see the discussion of privileges.
For a discussion of how to embed GRANT and REVOKE statements in programs, see the Informix Guide to SQL: Tutorial.