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