Re: [Squirrel-sql-users] Can't see table schema through SYNONYM, but SQL Developer can see it in "Other Users"

[KARR, D. <dk...@at...>]

> -----Original Message-----
> From: Alexandre Peshansky [mailto:Ale...@ei...]
> Sent: Friday, February 10, 2012 6:51 AM
> To: squ...@li...
> Subject: Re: [Squirrel-sql-users] Can't see table schema through
> SYNONYM, but SQL Developer can see it in "Other Users"
> 
> On Thu, Feb 09, 2012 at 2:34 PM, "KARR, DAVID" <dk...@at...> wrote:
> >
> > I have read-only credentials for an Oracle database.  We have to
> access
> > many of the tables through a synonym.  I can query them, but I can't
> see
> > the column definitions.  I can do completion on the column names in
> the
> > SQL buffer, but I'd still like to be able to see the column
> definitions.
> >
> > Someone else here uses SQL Developer to access the same database,
> using
> > the same credentials, and if they go to the "Other Users" section,
> they're
> > able to see the column definitions.
> >
> > Is there an analog of this in SQuirreL, or is it not possible to do
> this
> > at this time?
> 
> David,
> Did you select "Allow all Schemas" under "Oracle" tab in alias
> properties?

I just set that, and renewed my connection and refreshed my schema and redisplayed the "Columns" tab of a synonym, and it's still empty.

> > -----Original Message-----
> > From: KARR, DAVID [mailto:dk...@at...]
> > Sent: Thursday, February 09, 2012 2:34 PM
> > To: squ...@li...
> > Subject: [Squirrel-sql-users] Can't see table schema through SYNONYM,
> but
> > SQL Developer can see it in "Other Users"
> > ---------------------------------------------------------------------
> -----
> > ----
> > Virtualization & Cloud Management Using Capacity Planning Cloud
> computing
> > makes use of virtualization - but cloud computing also focuses on
> allowing
> > computing to be delivered as a service.
> > http://www.accelacomm.com/jaw/sfnl/114/51521223/
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 
> 
> -----------------------------------------------------------------------
> -------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users