Re: F4 Describe not working via Public Synonym?

In order to recreate it (because at first I had the same result as you), I had to refresh the SB LHS Tables tab.  I'm guessing this caches a list of tables which the editor uses.  I think it's the use of this list that is affecting the F4 functionality.

So in your instance, if you refresh the SB LHS Tables list so that your table appears in USERA's list of tables (note, I have the Filter -> Schema Name -> All except Sys selected so not just this users tables are returned*).  Then go back into your editor (the table name has probably changed colour to indicate it is recognised) and then F4 you should see the issue I am having.

*This would seem like a very likely candidate for the issue I'm experiencing. - actually, I just switched this option off, back to Current Schema Only, and now it's fine so it's definitely that filter option that is causing an issue.

--- In [email protected], John Dorlon <john.dorlon@...> wrote:
>
> Hi Richard,
> 
>   I just gave this a try but could not reproduce the problem.  I made 2 public synonyms - one with the same name as the object and one as a different name.  I could F4 on either one while logged in as USERA without any problems.   This is using Toad 11.5.0.56, same as you.  Let me know if I set up something wrong.
> 
> Thanks,
> John
> 
> create user usera identified by usera;
> grant create session to usera;
> create user userb identified by userb;
> grant dba to userb;
> create table userb.userb_tbl as select * from dual;
> create public synonym syn_userb_tbl for userb.userb_tbl;
> create public synonym userb_tbl for userb.userb_tbl;
> grant all on userb.userb_tbl to usera;
> 




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/