Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Different result sets for two different users

3679117Dec 2 2018 — edited Dec 2 2018

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

Comments
Post Details
Added on Dec 2 2018
4 comments
1,259 views