Hello,

This sounds really weird but happened in our database yesterday after we migrated to a 11g and RAC from single-instance 10g.

Only one user has trouble accessing tables of another schema after the migration.

Example:

1. Schema = user1
2. table name = tab1
3. role name = role1
4. user1 has given select privilege on tab1 to role1.

5. app user = user2
6. Contains no objects of its own
7. user2 is granted connect and role1 (both default)
8. select * from user1.tab1;
9. ERROR at line 1:
ORA-00942: table or view does not exist

Can anyone guess what the issue might be?
A reply at the earliest would be appreciated.

Thanks!
Suhas