When I compile my Package Body, I get the error: "PL/SQL: ORA-00942: table or view does not exist."
It works with my PROD1 user, but not in my PROD2 user. My PROD2 user is a new user that I created and copied from my PROD1 user. Running it in SQL Plus also generated the same error.
Try to re-grant access privileges to the synonym in question to the PROD2 user and/or also re-grant that synonym to PUBLIC.
and/or
Drop and recreate the public synonym after issuing grants on the table to PUBLIC.
Info from user:
User dropped / recreated the public synonym after issuing grants on the table to public. User can now compile the package body, and now could execute SELECT statement on the view that referred to the package body.
