| Subject | Re: Rights confusion with stored procedures and triggers | 
|---|---|
| Author | hvlad | 
| Post date | 2010-05-18T21:02:58Z | 
Error is here:
GRANT INSERT ON PERM_TBL TO PROCEDURE PERM_PROC
And here:
GRANT INSERT ON PERM_TBL TO PROCEDURE PERM_PROC
Regards,
Vlad
            > GRANT INSERT ON PERM_TBL TO USER PERM_PROCShould 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
Regards,
Vlad