Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

up vote 0 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.