| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Access with ACCESS
Unfortunately, not really. If your Oracle version is at least 8i (you don't
say which you're using), you could create a LOGON trigger where you could
glean the "PROGRAM" variable set by the client. The problem with this is
that MS can sometimes have very long path names to get to MSACCESS.EXE,
which will then be truncated by the "PROGRAM" size of 50 chars (or is it
64?). And different versions of Winders puts the forsaken tool in different
locations. You could *mostly* prevent ACCESS from access, but it can never
be 100%.
Rich
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Tuesday, October 15, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L
How do I stop users from accessing Oracle tables with Access? They have
rights to the tables in Oracle and should have those rights, yet I do not
want anyone to be able to pull the data off into an access database. Is it
possible to stop this without taking their privileges to the Oracle tables
away?
Thank you,
Laura
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 16 2002 - 10:39:32 CDT
 |
 |