Re: What driver is connecting to my database?

On 7 Sep 2006 13:19:45 -0700, "Ben" <balvey_at_comcast.net> wrote:

>Oracle 9.2.0.5 Ent Ed AIX5L.
>
>Is it possible to determine the driver / type of connection that is
>being used by different users to connect to the database.
>Our ERP system came with an ODA driver that is read only. If any of our
>users want to use MS Access to connect to our database they are
>supposed to use that driver with linked tables. We have had some data
>corruption lately with some rows being updated and some being deleted.
>No one is supposed to have the Ora92 driver to avoid this situation,
>but we are wondering if someone is using the Oracle supplied driver.
>How can I figure this out?
>
>Thanks

You are asking the wrong question. You should ask: why didn't I enforce integrity *in my database* so no one can create havoc, and we don't have to resort to tricks like using a driver which is supposedly 'readonly' (which doesn't exist of course).

--
Sybrand Bakker, Senior Oracle DBA