Laura, How will you stop someone spooling the output as csv and then load them into access?
If they have the access to the data, they'll always find a work-around, no matter what you try Regards Naveen -----Original Message----- Sent: Wednesday, October 16, 2002 9:10 PM To: Multiple recipients of list ORACLE-L 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
