Forgive me if I don't fully understand the problem you are trying to solve here but, why wouldn't you create the appropriate users and roles in Oracle to control access to the database objects?
You can, depending on the version of Oracle 10g you are running, create as fine grained access as...
Because it is possible to spoof application name, ip address, etc... there is really no practical way to restrict by application name. There are more then a couple threads on this on asktom.oracle.com
You might look at a secure application role. This would make connecting via an unauthorized...
I found my copy in C:\Program Files\NotesSQL. I didn't see it referenced in my ODBC administrator/Drivers tab. I did see NSQL32.dll there.
Since it is ODBC, I would expect the ODBC administrator only work with properly registered drivers. I would start there and if needs be, change the driver...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.