Question

Oracle can't see tables

Hi,

1. I have an Oracle schema ADMIN, and another schema APP.

2. All tables are created and owned by ADMIN, APP has selective grants to those tables.

3.I created public synonyms for all the tables under ADMIN.

4. I'm trying to connect the appian datastore to oracle using the APP schema.

5. None of the ADMIN tables are viewable from the APP datastore. (When I create a CDT from database, none of the tables show up in the dropdown.)

Why can't the APP user see the ADMIN tables?

Thanks,

Elisa

Brainy

Synonyms are not supported. Depending on your use case, you could create simple views pointing to these tables. Then Appian will see these.

Thank you for the response, Stefan-- is there additional documentation regarding this?

Can you elaborate more on "synonyms are not supported?" I'm under the impression that synonyms resolved the issue for the other thread: https://community.appian.com/discussions/f/data/10323/unable-to-find-table-or-view-for-oracle-db/45615#45615

Do you mean to create views in the APP schema that point to the ADMIN tables?

Brainy

According to

Appian only supports tables and views.

Create the views in that schema used for Appian.

Sign up