Oracle-L: RE: Access with ACCESS

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Wed, 16 Oct 2002 08:20:16 -0800
Message-ID: <F001.004EAAD7.20021016082016@fatcity.com>

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
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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------