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?
--
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534
Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr) (718) 920-4885 (Tu & Th)
> -----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
|