I am creating a Java application that connects to an Oracle Database.
In the application I connect to the DB as User A, which works as intended.
I then try to access tables in Schema 1 and Schema 2.
However when I do so I get the error:
ORA-00942: table or view does not exist
I looked in SQLDeveloper and in the "other users" section of User A I cannot see any tables for Schemas 1 and 2.
How can I solve this error so that I can see and access tables in Schemas 1 and 2?
Can I do this by assigning
GRANT SELECT privileges on User A for schemas 1 and 2?