Cannot see table
Table TEST was created by user SYSTEM to USER1.
Create Table USER1.TEST
(
field1 VARCHAR2(10)
);
Then user SYSTEM, created the public synonym:
Create Public Synonym TEST for USER1.TEST;
also.
Grant Select on USER2.TEST for CONNECT;
(USER2 has: CONNECT and RESOURCE privilidges).
USER2 cannot see table TEST. The only way is by putting the USER1.TEST
But is there any other way to proceed without "user.table" = user1.test?