ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lightswitch-I can’t see tables created bya different restricted Oracle user

934464May 2 2012 — edited Dec 10 2012

I am new to Lightrswitch and connecting to Oracle through VS - we usually have a middle tier to do this. We are looking at some rapid CRUD application development so I am looking into lightswitch.

However I have an issue:

I have two oracle users. One has full access to the tables and the other has restricted access. When attaching my Lightswitch application to the database if I use the one with full access it works a treat. However if I use the DB user that has restricted access I can not see any of the tables (even though I can see them fine logged in under the same restricted user in toad ?). Upon connection I have gone into the filters tab and selected the unrestricted schema under the "Displayed Schemas" option to no avail.

My version of Oracle is 9.2.0.7

I also have Oralce OLEDB provider - ODAC92070.exe

I have oracle developer tools ODTwithODAC1020221

Any help would be much appreciated...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2013

Added on May 2 2012

#odp-net

6 comments

768 views