Re: Limiting Oracle ODBC functionality

negandhi_at_io.org (Neil Negandhi) wrote:
>We've just installed the new Oracle ODBC driver and everything seems to
>work perfectly (we're running SQL*NET). However, before this tool is
>released to our users we'd like to limit its functionality. Right now,
>anyone with the driver and a little know-how can attach Oracle tables
>in Access and start to modify the data. Is there a way to limit users
>to read-access only? That way they could use Microsoft Query to pull
>data into Excel without data integrity being compromised.

Sure. Don't grant them update or insert permissions on the tables!

Of course, if you want them to have update/insert with **some** applications but not others, you're SOL. I'm in the process of designing a tool to provide such services, but it will be proprietary to our company. Supposedly there are commercial products out there to accomplish this task, but they seem to be in the same stage of development as Windows 95 - pretty demos but nothing shipping in the forseeable future.

Good luck!

--
Bill Meahan,  Senior Developer  |        wmeahan_at_ef0424.efhd.ford.com
Electrical & Fuel Handling Division, Ford Motor Company
Opions expressed herein are those of the author and in no way represent
any official statement or opinion of Ford Motor Company