CODEWITHSUNDEEP
sqloracle-databaseplsql
Keith
Keith

Reputation: 5

two users using same account, same code at same database but have different result

there are two database, DB1 for userA and DB2 for userB. A need get data from DB2 and A ask B for support. B use sql like below

select t.column1, t.column2, m.column3
from   view1 t, table1 m

and view1 statement like below

select a.column4, b.column5
from   view2 a, table2 b

B was granted view1 for userA and testing in DB1 by using userA account, like below

select t.column1, t.column2, m.column3
from   view1@lnk2db2 t, table1@lnk2db2 m

B's testing result shows information. but when A using same code, it only shows column but no data.

Question :

  1. by using same account, same code and compiled at same database and same time, did any reader(you) have the same experience?

  2. B only grant view1 to A but view2 not, is this the critical point?

thanks for your support and please let me know when any place didn't describe clearly.

Upvotes: 0

Views: 73

Answers (1)

eaolson
eaolson

Reputation: 15090

Are you using a Virtual Private Database? In that case, it's possible for two users to see different results when querying the same table.

Upvotes: 1

Related Questions