Re: MS Access interface to Oracle 7
Date: 1995/05/09
Message-ID: <3oovab$jtf_at_tst.hk.super.net>#1/1
Jim Fondren <jim_at_cartotech.com> wrote:
>
> ana_at_lamar.ColoState.EDU (Ana Silva) wrote:
> >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
>............
> tables. Instead, create multiple views and restrict update
> access to only the particular views that really need it.
>
> Hope this helps too :-)
>
> Jim F
>
Well, this technique is recommended by Oracle and is implemented in our company when we installed Oracle 6.0 some years ago. With the release of Oracle 7, DBA can make use of password protected role to solve this dilemma. You grant sufficient privilege to every user, assuming they always have the kind of access like sqlplus (i.e. manipulating directly) but reserved those very sensitive one to some password protected role to be enabled only in your application. Hope this would help.
Ammon Lee Received on Tue May 09 1995 - 00:00:00 CEST