Effect of the ALL Keyword

The ALL keyword revokes all table-level privileges. If any or all of the table-level privileges do not exist for the revokee, REVOKE with the ALL keyword executes successfully but returns the following SQLSTATE code:

01006--Privilege not revoked

For example, assume that user hal has the Select and Insert privileges on the customer table. User jocelyn wants to revoke all table-level privileges from user hal. So user jocelyn issues the following REVOKE statement:

REVOKE ALL ON customer FROM hal;

This statement executes successfully but returns SQLSTATE code 01006. The SQLSTATE warning is returned because both of the following are true:

• The statement succeeds in revoking the Select and Insert privileges from user hal because user hal had those privileges.
• SQLSTATE code 01006 is returned because user hal lacked other privileges implied by the ALL keyword, but these privileges were not revoked.