Hi,

> 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?

Yes - you reading the documentation :)

GRANT/REVOKE isn't allowed in stored procedures or triggers.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."