Re: Oracle database Security.

From: <sybrandb_at_yahoo.com>
Date: 12 Jan 2004 06:28:29 -0800
Message-ID: <a1d154f4.0401120628.c6225e3@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 Received on Mon Jan 12 2004 - 08:28:29 CST