Re: Restricting the capability of ODBC users

Ross Ellard (Ellard_at_DMLIS.zynet.co.uk) wrote:

[...]
: What I am wondering is whether there is anyway to configure the ODBC
: driver to only allow read access to the nominated data sources or even
: whether we can use some form of roles which can be set according to
: whether the user is accessing via ODBC or straight SQL or SQL*Net. I
: can't see how this latter option will work as my understanding is that
: ODBC uses SQL*Net anyway.

ODBC drivers does not have to use Oracle SQL*Net. Oracle's own ODBC driver does of course use SQL*Net.

Openlink's ODBC driver for Oracle does not use SQL*Net and can be configured to read-only-access. It also seems to have a lot of other advantages above Oracle's ODBC driver (performance, security, etc).

Haven't tried it yet. Currently evaluating options.

Lars Bruun Hansen

---
Unibank Securities                                       2 Torvegade
Unibank A/S                                              DK-1786 Copenhagen V
                                                         Denmark
Tel. +45 33 33 33 33         
Fax  +45 31 57 92 42          
E-mail: unibors_at_inet.uni-c.dk