Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to set ACCESS connection to Read-Only?

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

From: Michael O'Neill <mjoneill_at_email.com>
Date: Tue, 21 Nov 2000 03:24:37 GMT
Message-ID: <VVlS5.218792$g6.101342009@news2.rdc2.tx.home.com>

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

Wouldn't the best place to handle the security of your Oracle objects be at the Oracle object level, not the connectivity driver? Make sure the schema has only SELECT grants. Received on Mon Nov 20 2000 - 21:24:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US