all views are not visible in Tab "Tables and views"
BNitsche
Posts: 9 Bronze 1
i try to compare data from 2 different schemas. in schema a i have created a view and in schema b i also created a view. with user c i can see and execute both views. when i try to select the views in the tab "Tables and views" i cannot see the views. I can see no views in both schemas although there are other views in both schemas. What could be the reason for this?
Tagged:
Answers
I believe will are investigating this problem via a Support Ticket #161449, you submitted to the support team.
Will update this post when the support ticket is resolved.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com