Hi there,

It appears I cannot use GRANT or REVOKE in a trigger, but the manual
says that it can be used with SQL, DSQL, and ISQL.

SET TERM ^ ;
CREATE TRIGGER UPD_ROLE
ACTIVE AFTER DELETE POSITION 0
AS BEGIN
REVOKE old.USER_ROLE FROM old.USER_NAME;
END ^
SET TERM ; ^

Any ideas what I might be missing here?

Rgds,
-Ryan