Some options could be: - password protected roles - application roles (9i) - virtual private database
each being enabled via the applications that *you* control and thus not from Access. Some/all of the above could possibly be subverted in time by a smart and malicious user, but it should suffice in most cases hth connor --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
