Toad World® Forums

Dot lookup not working?


#1

Hi

please check this …maybe it just happens with me
The dot lookup seems that is not working in the following situations:

  1. I have a non-public synonym for a table on another schema
  2. I use a fully qualifier for the table ( .<table_name>) -> the schema is not the one connected to.

Thanks and regards

Filipe

Message was edited by: Fsilva


#2

Filipe,

It works at my place…
I checked with the following code:

select *
from a
where a.

A list of column names of the other-schema table (whether referenced through a private synonym or using the schema-prefix) appeared.

Maybe you need some sort of grant on the other schema’s tables or (more likely) some system privilege…


#3

I only have grant select