How Can I Configure an Oracle Data Source in Lightswitch to Map Tables Owned by Another User?

Question

We are using a SaaS provider at my company, who also offers direct read-only access to their back end Oracle database.

Our Oracle user does not own any of the tables, therefore the tables we want to read belong to other users. So the tables must be addressed as follows: OwnerUser.table1, OwnerUser.table2, etc.

When setting up a data source in LightSwitch, no tables are visible, because the Entity Data Model is mapping to tables owned by our user (the one which we connect with).

Does anyone know if I can tweak the data source somewhere to inject the owner prefix (e.g. OwnerUser) so that the LightSwitch Designer will show the tables owned by OwnerUser?

score 1 · Answer 1 · answered Jul 10 '12 at 03:19

1

You might find that in this case it might be easier to create a custom RIA Service layer for the datasource that passes the user information and sets up the tables.

answered Jul 10 '12 at 03:19

Mykre

56
3

That is always your 'get out of jail card' :) – Michael Washington Jul 10 '12 at 15:52
@Mykre Can you post a link to a doc where I can learn how to create a custom RIA Service Layer? I am not sure I know what that is. – qxotk Nov 04 '12 at 01:07

How Can I Configure an Oracle Data Source in Lightswitch to Map Tables Owned by Another User?

1 Answers1