FRM-40735: POST-QUERY trigger raised unhandled exception ORA-00942 on a multirecord datablock form as a new user.
Posted on 2004-09-28
The user that owns the tables runs the form fine with no errors but when I create a new user and grant privileges and create synonyms for the new user and then run the form as the new user I receive the following error FRM-40735: POST-QUERY trigger raised unhandled exception ORA-00942.
I have granted SELECT, INSERT, UPDATE, DELETE for the tables needed for the form to a new role I created named NETOPS_EMP. I have granted NETOPS_EMP role to my new user. I have logged in as my new user and created synonyms for the tables necessary for the form(matching table names exactly). I have sifted through my post query trigger for any line that might have schema specific path but there is none(which is good). I am kind of at a stuck point, is there any privilege I may be missing? I have even tried granting the dba role to the new user but I still have the same error. Its gotta a be a rights/privilege issue since the form works perfectly fine as one user and gets an error as a new user.
Thanks for your help!