Hi,
In 12.1.0 on Linux RedHat
I have a table called ATABLE.
I created a synonym:
CREATE OR REPLACE SYNONYM "USER1"."ATABLE" FOR "USER2"."ATABLE"
I have granted SELECT ON ATABLE to USER1.
When user1 run the following:
select count(*) from ATABLE;
ERROR at line 1:
ORA-01031: insufficient privileges
What do you suggest to investigate?
Thanks.