Very Computer

by **Mick Cook** » Sat, 06 Jun 1998 04:00:00

I have an oracle database from which users can create ad-hoc queries and
reports in MS Access via ODBC (V3 I believe) I now realise that they can
also update records in the linked tables which as you can imagine is not a
good idea.

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.

Any suggestions gratefully received
Thanks in advance

Mick C
Oracle DBA (beginner)

by **Luke Davi** » Sun, 07 Jun 1998 04:00:00

> I have an oracle database from which users can create ad-hoc queries and
> reports in MS Access via ODBC (V3 I believe) I now realise that they can
> also update records in the linked tables which as you can imagine is
> not a
> good idea.

> 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.

> Any suggestions gratefully received
> Thanks in advance

> Mick C
> Oracle DBA (beginner)

How about allowing select only access to another Oracle User and having
Access select the records through the read_only User?

Luke

by **Davi** » Sun, 07 Jun 1998 04:00:00

Surely all you need to do is revoke insert / update privs from these users,
unless they own the tables.

Regards
David Russell

>I have an oracle database from which users can create ad-hoc queries and
>reports in MS Access via ODBC (V3 I believe) I now realise that they can
>also update records in the linked tables which as you can imagine is not a
>good idea.

>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.

>Any suggestions gratefully received
>Thanks in advance

>Mick C
>Oracle DBA (beginner)

by **Jonathan Genni** » Mon, 08 Jun 1998 04:00:00

On 5 Jun 1998 22:05:10 GMT, "Mick Cooke"

>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

Very Computer

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

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

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

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

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