Re: Connecting to Oracle via ODBC and MS Access

In article <30FE4DA1.866_at_cho.ge.com> Chris Little <chris.little_at_cho.ge.com> writes:
>Subject: Connecting to Oracle via ODBC and MS Access
>From: Chris Little <chris.little_at_cho.ge.com>
>Date: Thu, 18 Jan 1996 13:39:45 +0000
 

>Through a third party application all users have privileges to
>modify data in various Oracle tables. This is fine since tha
>application contains all the necessary rules, joins, etc.
 

>Now our users want to use MS Access as a front end to Oracle,
>for readonly reporting and manipulation activity only. If they
>modify the Oracle tables through this MS Access front end,
>they'll destroy the integrity of the database.
 

>Does anyone know how I can allow the users to use MS Access in
>readonly mode. I could give them a "readonly" Oracle account,
>but they still have their personal Oracle accounts for running
>the third party application described above.

Use a non-default role with a password in it to grant write access to the users. Enable the role inside the app with the password. As long as you never give the password to the users they are restricted to read only.

Lawrence.......

>Thanks in advance for your help.
 

>--------------------------------------------------------------
>cHRIS lITTLE, oRACLE dba & sap bASIS aDMIN.
>ge fANUC aUTOMATION, cHARLOTTESVILLE, vIRGINIA, (804) 978-5945
Received on Wed Jan 24 1996 - 00:00:00 CET