I was hoping someone could help me with a little code assist annoyance I’m
facing.
I have Toad 9.7.2.5 installed.
I login as user scott.
Then type:
Select *
From a.
into my editor where “a” is a schema. As expected I am prompted with
the list of database objects that I would expect based on the configuration
settings under View >> Toad Options >> Code Assist.
However If I type:
Select *
From b.
I am prompted, but the schema name only, “b”, is shown with no
objects.
This seems like a role/grant issue except that the roles and grants seem the
same for both schemas except that they refer to different objects.
I can see all the tables in both from the Schema Browser. I can query ALL_TABLES
and see the tables from both schemas.
Has anyone else seen this? I still think it’s at bottom a grant issue, but
would love to know what db objects are in play. I have verified that code assist
for multiple schemas works when connected to a completely different set of
schemas in another instance.
Thanks.
Ed.