Re: ODBC and Oracle

From: Ed Prochak <prochak_at_my-deja.com>
Date: Thu, 09 Mar 2000 03:43:02 GMT
Message-ID: <8a76k6$n8u$1@nnrp1.deja.com>

How helpful are the DBA's? If they can change the priveleges in ORACLE to restrict access to the other table. I don't know if that will work, but that's what I would try.

In article <38c70662_at_pink.one.net.au>,
"Mike Layng" <mlayng_at_micromine.com.au> wrote:
> Thanks for your reply Thorsten,
>
> I am working with an old app that we actually had running on a
Paradox Dos
> database. The application creates a lot of SQL statements
dynamically and
> at this stage it is not feasible for us to force these statements to
use
> <owner>.<tablename>. I was sort of hoping that there was some way of
> avoiding this.
>
> Thanks,
> Mike.
>
> Thorsten Bertram <thorsten.bertram_at_planware.com> wrote in message
> news:8a58tt$1tad$1_at_wrath.news.nacamar.de...
> > Hi Mike,
> >
> > set the owner of the table in front of the table name, which means
> > "Select * from <owner>.<tablename>".
> >
> > I think that will solve your problem.
> >
> > regards
> > Thorsten
> >
>
>

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 08 2000 - 21:43:02 CST