Re: Preventing table update when linking oracle database table to access via ODBC

Home -> Community -> Usenet -> c.d.o.server -> Re: Preventing table update when linking oracle database table to access via ODBC

From: Luke Davies <luked_at_cix.co.uk>
Date: 6 Jun 1998 15:03:20 GMT
Message-ID: <memo.19980606155808.4101E@luked.compulink.co.uk>

In article <01bd910f$20670000$d1055cc3_at_default>, mickc_at_acecomp.softnet.co.uk (Mick Cooke) wrote:

> I have an oracle database from which users can create ad-hoc queries and
> reports in MS Access via ODBC (V3 I believe) I now realise that they can
> also update records in the linked tables which as you can imagine is
> not a
> good idea.
>
> Is there any way (software tools) that I can allow users to create
> queries
> and reports without the possibility of changing the data in the oracle
> database.
>
> Any suggestions gratefully received
> Thanks in advance
>
> Mick C
> Oracle DBA (beginner)
>
>
>

How about allowing select only access to another Oracle User and having Access select the records through the read_only User?

Luke Received on Sat Jun 06 1998 - 10:03:20 CDT