Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I prefix the table name with the username either.

I've also created a public synonym for the new table but am still having the issue.

User A cannot access any objects out of B (even with prefixing), but user B can access objects from user A (has to prefix).

What am I missing?

Thankyou

share|improve this question
up vote 1 down vote accepted

have you granted select rights on B's table?

connect userb/password    
grant select on table_from_b to usera;

connect usera/password
select * from userb.table_from_b;
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.