REVOKE The REVOKE statement allows to remove users and permissions. General format EXEC SQL [AT Database] REVOKE Options END-EXEC Syntax rules 1. Options is passed to the driver without further checks. Refer to the database documentation for detailed syntax. Syntax errors, if any, are returned at runtime. General Rules 1. Database identifies the active connection that will execute the query and must be previously defined using a Format 4 DECLARE statement. Examples Revoke Update and Delete access privilege to a table from some users exec sql revoke update, delete on invoices from usr1, erollands end-exec
