1

Oracle- Can't access objects from other users schema

view story
linux-howto

http://serverfault.com – 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 (HowTos)