Subject Re: Rights confusion with stored procedures and triggers
Author hvlad
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

Regards,
Vlad