Re: MS Access interface to Oracle 7
Date: 1995/05/04
Message-ID: <3ob2rd$3tuf_at_lamar.ColoState.EDU>#1/1
John Malathronas (John_at_scroll.demon.co.uk) wrote:
: Indeed you can. This is a big problem, because once you
: have installed ODBC and SQL*Net 2.0 - your users can go
: directly to the tables and bypass any of your forms, be
: they Visual Basic or ACCESS or Forms 4.5. Once you have
: granted update/delete access to a table, thinking that
: your user will always use a particular form, the user
: can fire up Access and have access to the table records
: RAW. It is terrible. It's as if you are giving all
: your users SQLPLUS access to your database.
We're thinking about taking care of this problem by using
roles. To start, nobody has update/delete rights to anything.
Whenever the form starts (startup trigger) it creates
the roles granting permission to the specific users, allowing
to change the table. When the user exits the form (post-form
maybe) it "deletes" the role. We're still working on this,
so I don't have all the details.
Hope this helps,
Ana Received on Thu May 04 1995 - 00:00:00 CEST