Connecting to Oracle via ODBC and MS Access
From: Chris Little <chris.little_at_cho.ge.com>
Date: 1996/01/18
Message-ID: <30FE4DA1.866_at_cho.ge.com>#1/1
cHRIS lITTLE, oRACLE dba & sap bASIS aDMIN. ge fANUC aUTOMATION, cHARLOTTESVILLE, vIRGINIA, (804) 978-5945 Received on Thu Jan 18 1996 - 00:00:00 CET
Date: 1996/01/18
Message-ID: <30FE4DA1.866_at_cho.ge.com>#1/1
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.
Thanks in advance for your help.
cHRIS lITTLE, oRACLE dba & sap bASIS aDMIN. ge fANUC aUTOMATION, cHARLOTTESVILLE, vIRGINIA, (804) 978-5945 Received on Thu Jan 18 1996 - 00:00:00 CET