2 Replies Latest reply on Aug 30, 2021 11:47 AM by Alan Howatt

    Oracle connection need for schema name synonym

    Alan Howatt Active Member

      Question: Do we need to create private synonyms for objects owned by other users or is there a way to use  the public synonyms?

      When creating an oracle connection using a "batch" id that is not a data schema owner  I noted that no tables show up unless a schema is specified in the connection definition.  All our data tables have public synonyms and we can import sources in Power Center using our "batch" user. I then created some private synonyms for the tables in question and when I connect I can see those tables now using "batch" , but still can't see the ones with public synonyms.