Re: Oracle database Security.

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 12 Jan 2004 17:26:33 +0100
Message-ID: <4002ca73$0$28715$626a54ce@news.free.fr>

<sybrandb_at_yahoo.com> a écrit dans le message de news:a1d154f4.0401120628.c6225e3_at_posting.google.com...
> g_jesu_at_hotmail.com (Jesu) wrote in message
news:<dbb3be0c.0401120055.11b76a26_at_posting.google.com>...
> > Hi,
> > Can any one suggest, how to prevent inserting or deleteing records
> > in oracle table through MS Access or VC ++ project window.
> >
> > Thanks in advance
> > Jesu.
>
> Set up 2 roles: one with full access rights, the other with select
> only access rights. Enable the latter role by default, do not enable
> the former role , other than in your application, the former role can
> of course be enabled programmatically but most end-users won't know
> how to do that.
>
> Sybrand Bakker
> Senior Oracle DBA

And users can even less modify the data if the role is defined with a password which is only known by the application (role identified by password). And even less if the Secure Application role are used (role identfied using a package).

Regards
Michel Cadot Received on Mon Jan 12 2004 - 10:26:33 CST