We have an EBS database (version 12.1.0.2) with R12 items that use the synonym construct: synonym owned by apps (APPS.CST_ITEM_COSTS) -> editioned view owned by application (BOM.CST_ITEM_COSTS#) -> base table owned by application (BOM.CST_ITEM_COSTS).
I am not a DBA - I'm a developer and we have been instructed that all of our code migrations must go through a special user set up for migrations (let's call this DBA_MIG).
When I log into DBA_MIG and run my grant, I get the grant succeeded message but when I try to use the synonym from the granted user (customuser), I get insufficient privileges.
GRANT SELECT ON apps.cst_item_costs TO customuser;
If I run the same statement from apps, I get the same "Grant succeeded" message but the grant works for user customuser. Is there something else needed for the DBA_MIG user to allow this to work? Or something I need to add to the grant statement when run from DBA_MIG to make it work?