Re: Selectively Control ODBC Access? How?

Isn't there a way for an app to dynamically assign roles in Oracle to each user to prevent this kind of thing ? Maybe someone out there in Oracle land know the details on how this works ?

Rock Cogar.

In article <382B92A2.F9CA5FB9_at_dollargeneral.com>,   Roger Westbrook <rwestbrook_at_dollargeneral.com> wrote:
> Ok, there has to be a way to do this.
>
> We've got a 3rd party app which uses ODBC to connect to our
Oracle 7.3.4.2 database running on our AIX 4.3.2 box. Each user has their own username but due to the nature of the app each user has pretty much total authority to most of the app's tables. There is a lot of protection built into the app, of course, but that doesn't stop anyone from using that same ODBC link to connect without benefit of the app's controls. So you see where this is going... Once ODBC was set up for the app's connectivity we had a few users who "discovered" that you can access the same database with MS ACCESS. Needless to say, I cannot allow this.
> I've already had one of them who decided she didn't like the
Transportation Status Codes and wanted change them to something she thought would be more logical. Luckily the referential constraints stopped her and I she came to my desk to ask me if she could borrow my SQL books. I almost had heart failure when as she explained what she wanted to do and how.
>
> So...
>
> I must have the ODBC link for the 3rd party app.
>
> I cannot allow applications like MS Access, or MS Query, etc to
connect.
>
> I cannot take MS Access, etc, off their desktops because they use it
for other things.
>
> I'm losing sleep over what these morons might do to my data!! What
can I do?
>
> Thanks in advance,
> Roger Westbrook, DBA/Sys Admin
> Dollar General Corp
> rwestbrook_at_dollargeneral.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 07:55:35 CST