Subject Re: [firebird-support] Rights confusion with stored procedures and triggers
Author PenWin
> It works for me using the following GRANT statements:
>
> GRANT INSERT ON TABLE PERM_LOG TO GURKO !!
> GRANT INSERT ON TABLE PERM_TBL TO GURKO !!
> -- GRANT INSERT ON TABLE PERM_TBL TO PERM_PROC !!
> GRANT EXECUTE ON PROCEDURE PERM_PROC TO GURKO !!
> GRANT GURKO TO USER GURKI !!
> COMMIT !!

Unfortunately, with this setup, the user can write to both PERM_TBL and
PERM_LOG directly, bypassing the procedure. That is to be avoided if at
all possible, for security reasons.

Pepak