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

On Wed, 18 Feb 1998 09:46:49 +0000, Allan Gould <allang_at_sco.com_no_spam> wrote: Hi,

why not handle this in oracle. Grant only select - privelege to the ODBC-users and no update or insert privelege.

>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)
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de