Re: Preventing table update when linking oracle database table to access via ODBC

Home -> Community -> Usenet -> c.d.o.server -> Re: Preventing table update when linking oracle database table to access via ODBC

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 07 Jun 1998 17:04:33 GMT
Message-ID: <6leh6v$h5e@bgtnsc02.worldnet.att.net>

On 5 Jun 1998 22:05:10 GMT, "Mick Cooke" <mickc_at_acecomp.softnet.co.uk> wrote:

>Is there any way (software tools) that I can allow users to create queries
>and reports without the possibility of changing the data in the oracle
>database.

My first suggestion would be to create a role that gives only SELECT access to the data, grant that role to the users, and then revoke any other privileges they may currently have on the tables in question. This will work, provided that they don't need to use the same user-id with an application that DOES allow them to update the data. Do they need to do that?

Jonathan Received on Sun Jun 07 1998 - 12:04:33 CDT