Subject | Re: [firebird-support] Rights confusion with stored procedures and triggers |
---|---|
Author | PenWin |
Post date | 2010-05-18T05:18:34Z |
> It works for me using the following GRANT statements:Unfortunately, with this setup, the user can write to both PERM_TBL and
>
> 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 !!
PERM_LOG directly, bypassing the procedure. That is to be avoided if at
all possible, for security reasons.
Pepak