ORACLE SQL DEVELOPER 看不到所有View
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/19284615/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORACLE SQL DEVELOPER can't see all View
提问by ricardo
SQL DEVELOPER does not list all the views I can see thru select * from all_views
SQL DEVELOPER 没有列出我可以通过 select * from all_views 看到的所有视图
Why I can see the view using the query builder and the Sql Developer do not show the views on the left pane?
为什么我可以使用查询构建器看到视图,而 Sql Developer 没有在左窗格中显示视图?
I already checked the option 'include synonyms' from the filter.
我已经从过滤器中选中了“包含同义词”选项。
I am not the owner of the view.
我不是视图的所有者。
EDITED:
编辑:
I found the answer with the help of Glenn and Sean
我在 Glenn 和 Sean 的帮助下找到了答案
The answer is:
答案是:
1 - you have to go to your oracle conection
1 - 你必须去你的预言机连接
2 - right click and select 'Schema Browser'
2 - 右键单击并选择“架构浏览器”
3- Now you can select the schema and see the views it have.
3- 现在您可以选择架构并查看它的视图。
Regards
问候
采纳答案by Sean Dulin
all_views (as well as the other "all_*" tables) only show entries in your schema or that you have access to. dba_views will show all views in the database. Your user probably does not have read access to the view via direct grants to your user or granted through a role.
all_views(以及其他“all_*”表)仅显示架构中的条目或您有权访问的条目。dba_views 将显示数据库中的所有视图。您的用户可能没有通过直接授予您的用户或通过角色授予对视图的读取访问权限。
all_views - all views you have access to + views in your user's schema user_views - all views in your user's schema dba_views - all views in the database
all_views - 您有权访问的所有视图 + 用户架构中的视图 user_views - 用户架构中的所有视图 dba_views - 数据库中的所有视图