SQLDeveloper在显示表的连接下不显示任何表 [英] SQLDeveloper displays no tables under connections where it says tables

问题描述

我不确定为什么，但是我只安装了SQLdeveloper 32位(3.0.0.4).当我单击以展开表/视图/索引等时，它什么也没有显示！

I am not sure why but I just installed SQLdeveloper 32 bit (3.0.0.4). When I click to expand the tables/views/indexes or etc it displays nothing at all!

但是当我执行以下操作时:

But when I do the following:

SELECT owner, table_name   
FROM dba_tables 

我看到了表列表，并且可以读取这些表，因为我可以从任何表和数据显示中进行选择*.有什么想法吗?

I see the list of tables and I have read access to these tables since I can do a select * from anytable and data shows. Any thoughts?

推荐答案

SQL Developer树向您显示您拥有的对象，而不是您有权访问的对象.如果要查看其他用户拥有的有权访问的对象，则需要导航到树的其他用户"分支，然后导航到拥有表的用户，再导航到表"分支.

The SQL Developer tree shows you what objects you own, not what objects you have access to. If you want to see the objects that you have access to that are owned by other users, you would need to navigate to the "Other Users" branch of the tree, then the user that owns the table, then the "Tables" branch.

这篇关于SQLDeveloper在显示表的连接下不显示任何表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！