Ben wrote:
> Sybrand Bakker wrote:
>> 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
>
>
> Sorry, I didn't design the database. I just took it over when my
> company laid the only DBA off. Every environment in this World isn't
> perfect. There being, yes, sometimes you have to do work arounds to
> accomplish something. Our database environment is a mess, I can't help
> that, all I can do is try to improve it, and that is what I'm doing.
> And the JDE ODA odbc driver is supposedly read only, if it is not then
> JDE/Peoplesoft/Oracle have some explaining to do.
> I just asked a question, I have read ( and appreciate) your information
> that you give Sybrand. Can you help me out here, or is there not a way
> of doing this?
> Thanks,
> Ben
I've never seen any means of doing so.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Thu Sep 07 2006 - 21:37:13 CDT
