Connecting as different Oracle schema user for reportcenter Oracle datasource

sgouin

It seems when creating a jdbc datasource in RC, you need to connect as the table schema owner?

 

We dont have direct access to table schema user, but have other schema users that have required privileges to read and see the tables in the other schema.

 

Seems as though report center by default only looks up current schema tables and cannot extend beyond that...

 

By design?

sgouin

Sorry... seems proper rights weren't assigned to schema user i was connecting as... RC does pull up tables owned or granted access via grant and synonyms.

 

disregard this thread. :-)