I can’t see tables created under a different (restricted) Oracle user.

Question

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. If it is any help when the tables are not displayed and I click the previous button the Displayed Schemas has reverted to the original value of just the restricted schema.

Answer 1

Hi,

I'm not familar with Oracle. But for such kind of issues getting a SQL trace on db server should be helpful for you to troubleshooting. From what SQL query fails you can investigate further. You can also compare what the toad tool sent v.s. what LS app sent to server to see what the difference is.

---

Allen Chen [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.