Subject Re: [firebird-support] Re: Rights confusion with stored procedures and triggers
Author Michael Ludwig
hvlad schrieb am 18.05.2010 um 21:02:58 (-0000):

> Error is here:
>
> > GRANT INSERT ON PERM_TBL TO USER PERM_PROC
>
> Should be
>
> GRANT INSERT ON PERM_TBL TO PROCEDURE PERM_PROC
>
> And here:
>
> > GRANT INSERT ON TABLE PERM_TBL TO PERM_PROC !!
>
> Should be again
>
> GRANT INSERT ON PERM_TBL TO PROCEDURE PERM_PROC

Thanks! I should have been reading the output I made the script
generate ... On the other hand, I had assumed the server would know
that PERM_PROC is a procedure, rather than a user. I'll keep that
in mind ... Thanks again!

--
Michael Ludwig