Xref: alice comp.databases.oracle.server:22290
From: "David" <darussell@msn.com>
References: <01bd910f$20670000$d1055cc3@default>
Subject: Re: Preventing table update when linking oracle database table to access via ODBC
Date: Sat, 6 Jun 1998 23:06:59 +0100
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <O3AgreZk9GA.252@upnetnews05>
Newsgroups: comp.databases.oracle.server
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.internetmci.com!207.68.143.79!upnetnews03!upnetnews05

Surely all you need to do is revoke insert / update privs from these users,
unless they own the tables.

Regards
David Russell

Mick Cooke wrote in message <01bd910f$20670000$d1055cc3@default>...
>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)
>
>