Re: ODBC Oracle-Access for Read-Only use?

From: Allan Gould <allang_at_sco.com_no_spam>
Date: 1998/02/18
Message-ID: <34EAAE08.56D5AC0@sco.com_no_spam>#1/1

Juan Antonio Martínez wrote:

> ODBC for Read Only use?
> I need to see some tables from Oracle in Access-97 with Oracle 7 Drivers
> for ODBC, but the data in Access must be not allowed to modify. Although I
> set permissions
> in these tables on Access, the user can use always ODBC in another MDB
> where there is no permissions on the tables.
> Is there any way to see tables with ODBC in read-only mode?
>
> Any guidance would be appreciated
>

You could try our ODBC driver: SCO SQL-Retriever. We offer a Security Manager which (among other things) allows you to make the ODBC link read-only and select users by SQL, table and database etc. Take a look at http://www.sco.com/vision/products/sqlretriever/ for more information and a downloadable eval.

Allan Gould
(allang at sco dot com)
(Please remove anti-spam measures if replying) Received on Wed Feb 18 1998 - 00:00:00 CST