avatar image
Former Member

Data Foundation cannot see PUBLIC schema

While creating data foundation in Universe in Information design Tool (IDT), the option Insert table does not show any of the PUBLIC schema synonyms or tables. Parameter "Include Synonyms" has been set to "True" at client and server level. User used for connection has been tested with other tools (TOAD, SQL Plus) and not problems accessing the PUBLIC schema there.

Any idea of what can be the problem with IDT?

We are BO 4.2 SPS 2 Patch 6 conecting to Oracle 11g.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2016 at 10:33 PM

    Can we make sure we have created Public synonyms at oracle level . If not the private synonym should have been created by the user who owns the connection.

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content