Geek Answers Handbook

Why can't I see tables / sequences in the toad schema browser?

Using Toad 9.7.2 for Oracle DB Network (10g) I do not see any objects in the schema browser using the account information provided to me by my database administrator. Using Oracle 10g installed locally, I see all the objects in my local Oracle instance using the account you created that has all privileges. I believe this is an example where the account provided to me by my database administrator does not have sufficient privileges in the database or Oracle directory?

Is there any specific privilege I need to request from my database administrator for this account in order to be able to use the Toad schema browser against a shared database?

Thanks for any / all answers.

+2
source share
2 answers

Stupid of me. There you will see the Toad schema browser, which allows you to change the appearance of the tables that you see for each owner. By default, the user enters the username. When I change the owner to the actual owner of the table, I can see the tables in order.

Thanks for reading / responding.

+5
source

To view, you need the SELECT privilege to view.

Log in to the database using the account you provided. Run the following select statement to see all the tables available to you:

SELECT owner, table_name 
  FROM all_tables;

If you do not see any tables from the schema, in your opinion, you should have access, then you have the privilege.

+1

More articles:


All Articles