Hello
I have a view called v_employees in schema
scott and select grant is provided to schema
tom in same database.
When I run a sql query from schema scott I could see records as results.
I have a created a synonym in schema tom
CREATE SYNONYM EMPLOYEES FOR scott.v_employees.
When I run .
select * from EMPLOYEES.
from schema tom, I cannot see any results.
What could be the reason for this?