Subject | Re: [firebird-support] Re: Rights confusion with stored procedures and triggers |
---|---|
Author | Michael Ludwig |
Post date | 2010-05-18T22:14:58Z |
hvlad schrieb am 18.05.2010 um 21:02:58 (-0000):
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
> Error is here:Thanks! I should have been reading the output I made the script
>
> > 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
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