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

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_at_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)
>
>
Received on Sat Jun 06 1998 - 17:06:59 CDT