Hello.
We are currently facing an issue whereby one SELECT query is returning different results for two different users.
There's a view to which access has been granted as follows to both users:
grant select on proddb.CUSTOMERS_VIEW to user_a;
grant select on proddb.CUSTOMERS_VIEW to user_b;
In addition, a synoym has been created as follows:
CREATE PUBLIC SYNONYM CUSTOMERS_VIEW FOR proddb.CUSTOMERS_VIEW;
When logged in as user_a and querying SELECT * FROM CUSTOMERS_VIEW, we get results.
However, when doing same logged in as user_b there are no results obtained.
Any idea where I should check for any issues?
CREATE PUBLIC SYNONYM BNR_READINESS FOR brduat4.BNR_READINESS;
CREATE PUBLIC SYNONYM BNR_SHMEMBERS FOR brduat4.BNR_SHMEMBERS;
grant select on brduat4.BNR_CUST to bnr_testuser;
grant select on brduat4.BNR_ACCT to bnr_testuser;
In