Hi,
I have only question if it really works as I think.
I'm using FB2.1 on Win2003.

We have two SQL users - admin and reader

I add one trigger - before update.

This trigger check the change of two columns (cathegory, id_ex) from table and if they
match the check it do same changes in new.xxx values and update 2 other tables. These two
columns can be changed only by admin user, reader user can only read them.

But when reader user try to change two other columns in the same table, it can't because
he has no right to do changes that are in this new trigger.
But he can never execute the body of the trigger, because of the check on start of the
trigger.

Is it necessary to check the dependences for all ways it can go in triggers and procedures
before execution???

Why ?? Is it so complicated to do it when the change/select/execution of procedure have to
be done??

Thanks, Tomas