🚀 go-pugleaf

Hello:

I have a problem with permissions when a procedure is executed in a 
trigger.

The trigger belongs to table A, and updates tables B, C or D.

The role doesn't have permissions for update on tables B, C nor D but it 
   does on A.  I gave permissions to the procedure:

grant all on ordenes_compra to procedure sp_entrada_satisface_docs; //
grant all on ordenes_compra_detalles to procedure 
sp_entrada_satisface_docs;
grant all on pedidos_tesoreria to procedure sp_entrada_satisface_docs;
grant all on pedidos_tesoreria_detalles to procedure 
sp_entrada_satisface_docs;
grant all on transferencias_materiales to procedure 
sp_entrada_satisface_docs;
grant all on transferencias_mat_detalles to procedure 
sp_entrada_satisface_docs;

But I keep on getting the error:

This user does not have privilege to perform  this operation  on this 
object.  no permission for update/write access  to table ORDENES_COMPRA.

table ORDENES_COMPRA is updated by a trigger fired by the update on 
table ordenes_compra_detalles which is updated by the procedure I just 
gave permissions to update on both tables.

Any help would be appreciated.

I'm using interbase 6.01 opensource

aa