Xref: alice comp.databases.oracle.server:22274
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!peernews.ftech.net!peernews.cix.co.uk!news.cix.co.uk!not-for-mail
From: luked@cix.co.uk (Luke Davies)
Newsgroups: comp.databases.oracle.server
Subject: Re: Preventing table update when linking oracle database table to access via ODBC
Date: 6 Jun 1998 15:03:20 GMT
Organization: CIX - Compulink Information eXchange
Lines: 27
Message-ID: <memo.19980606155808.4101E@luked.compulink.co.uk>
References: <01bd910f$20670000$d1055cc3@default>
Reply-To: luked@cix.co.uk

In article <01bd910f$20670000$d1055cc3@default>,
mickc@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