toad version : 9.7
When taking schema browser , It is showing all other schemas.
My current schema doesn’t have privilege to view other schema objects. So it is not showing objects.
But SCHEMA DROP-DOWN showing all other schemas.
Can we avoid displaying other schemas in toad?
Go to main Toad options window.
On the left, select Schema Browser -> Data.
On the right, where it says “User/Schema lists”, set it to “only show users that own objects”.
That might not eliminate all of them, but it should help.
It works.
As you said , It doesn’t eliminate all. But user schemas disappeared .
Thank you.
If you upgrade to at least Toad 12.1, you’ll be able to customize the schema dropdowns to show/hide whatever you want, and you’ll be able to categorize what is shown
http://documents.quest.com/toad-for-oracle/12.1/guide-to-using-toad-for-oracle/chapter-1-getting-started/customize-toad/customize-schema-drop-downs