Re: How to set ACCESS connection to Read-Only?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 Nov 2000 23:47:18 +0100
Message-ID: <974791258.892.1.pluto.d4ee154e@news.demon.nl>

"Yi Jin" <yijin_at_wam.umd.edu> wrote in message news:8vc5ur$8d3_at_rac5.wam.umd.edu...
>
> Our Oracle 8.1.5 database resides on a Solaris(SPARC) system. I've setup
> NT 4 connection to the database through MS ODBC driver. It works fine,
> except that I want read-only access from NT. How can I achieve that?
> I am using MS ACCESS.
>
> Also, is there anyway that a client is required to specify 'COMMIT'
> before save the change? Or set the default to 'autocommit off'?
>
> Many thanks.
>
> YJ

Answer to the first question.
Create a role in Oracle. Grant select privileges *only* on all tables to that role. Grant that role to the user, making it the only *default* role (set role <rolename> default).
As users are unable to enable roles (issuing such a command would start a second session), they will have select privilege only. Answer to the second question;AFAIK this is a feature of ODBC/Access.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Nov 20 2000 - 16:47:18 CST