为什么我在Toad的架构浏览器中看不到表格/序列? [英] Why can't I see Tables/Sequences in Toad's Schema Browser?

问题描述

在网络Oracle DB(10g)上使用Toad 9.7.2，使用我的DBA提供给我的帐户信息，在模式浏览器中看不到任何对象.使用本地安装的Oracle 10g，我使用创建的具有所有特权的帐户查看本地Oracle实例中的所有对象.我相信这是我的数据库管理员向我提供的帐户在数据库或Oracle目录中没有足够特权的一个实例吗?

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?

我是否需要为该用户帐户请求DBA特定特权，才能针对共享DB使用Toad的架构浏览器?

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?

提前感谢任何/所有回复.

Thanks in advance to any/all replies.

推荐答案

愚蠢的我. Toad模式浏览器上有一个下拉列表，可让您更改为每个所有者查看的表视图.默认为您登录时使用的用户.当我将所有者更改为实际的表所有者时，可以看到表很好.

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的架构浏览器中看不到表格/序列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！