Why can't I see Tables/Sequences in Toad's Schema Browser?

oracle privileges toad
Griff picture Griff · Aug 23, 2010 · Viewed 45.5k times · Source

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?

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.

Answer

Griff picture Griff · Aug 23, 2010

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.

Thanks for reading/replying.

Related questions

How to show all privileges from a user in oracle?

Can someone please tell me how to show all privileges/rules from a specific user in the sql-console?

Read More
ORA-01950: no privileges on tablespace 'USERS'

I'm getting this error: ORA-01950: no privileges on tablespace 'USERS' I have a default tablespace and I'm able to create tables, however, they do not show at the objects tab in Toad. I cannot insert anything into tables I create.

Read More
How do I get column datatype in Oracle with PL-SQL with low privileges?

I have "read only" access to a few tables in an Oracle database. I need to get schema information on some of the columns. I'd like to use something analogous to MS SQL's sp_help. I see the table I'm …

Read More