oracle 为什么我在 Toad 的架构浏览器中看不到表/序列？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3548927/
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
Why can't I see Tables/Sequences in Toad's Schema Browser?
提问by Griff
Using Toad 9.7.2 against a network Oracle DB (10g) I can't see any objects in the schema browser using the account information provided to me by my DBA. Using Oracle 10g installed locally, I see all objects in my local Oracle instance using the account I created which has all privileges. I believe this is an instance where the account provided to me by my DBA does not have sufficient privileges in the DB or to the Oracle catalog?
针对网络 Oracle DB (10g) 使用 Toad 9.7.2 我无法使用 DBA 提供给我的帐户信息在模式浏览器中看到任何对象。使用本地安装的 Oracle 10g，我使用我创建的拥有所有权限的帐户查看本地 Oracle 实例中的所有对象。我相信这是一个实例，其中我的 DBA 提供给我的帐户在 DB 或 Oracle 目录中没有足够的权限？
Is there a specific privilege I need to request of my DBA for this user account to be able to use Toad's schema browser against the shared DB?
我是否需要向我的 DBA 请求此用户帐户的特定权限才能针对共享数据库使用 Toad 的架构浏览器？
Thanks in advance to any/all replies.
预先感谢任何/所有回复。
回答by Griff
Stupid me. There's a drop down on the Toad schema browser that allows you to change the view of tables you see for each owner. It defaults to the user you login as. When I change the owner to the actual table owner, I can see the tables fine.
愚蠢的我。Toad 架构浏览器上有一个下拉菜单，允许您更改为每个所有者看到的表的视图。它默认为您登录的用户。当我将所有者更改为实际的表所有者时，我可以很好地看到这些表。
Thanks for reading/replying.
感谢阅读/回复。
回答by DCookie
You need SELECT privilege on the tables in order to see them.
您需要对表具有 SELECT 权限才能查看它们。
Log in to the database using the account you were provided. Issue the following select statement to see all the tables you have access to:
使用您提供的帐户登录数据库。发出以下 select 语句以查看您有权访问的所有表：
SELECT owner, table_name
FROM all_tables;
If you don't see any tables from the schema you think you should have access to, then you have a privilege issue.
如果您没有看到您认为应该有权访问的架构中的任何表，那么您就有了权限问题。
