Re: access/oracle

Using a logon trigger works until they figure out that renaming the executable will let them in.

Jared

rabbit_at_emirates.net.ae
Sent by: root_at_fatcity.com
 02/02/2003 08:13 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: access/oracle

We had same problems at 2 sites here. I dont allow access in Production, I can usually scare management enough to keep them out and I apply a LOGON trigger to stop any connection from access (and SQLPLUS etc for that matter, unless its a user that I allow). I do create a copy of PROD every day to TEST and they can do what they like on this database.

• Original Message ----- Date: Monday, February 3, 2003 4:38

> Bill,
> I have to live with people who want to usc Access too. I agree
> wfth you it is a
> pain in the a--. Our solution, with damagement's agreement, is to
> only do what
> is possible. I think that in your situation you'll have to do
> likewise. The
> problem being Access's local tables. What may help is if they
> link the tables &
> apply the appropriate limits on each.
>
> Dick Goulet
> becker.bill_at_marshfieldclinic.org wrote on 1/31/03 2:24 pm:
>
>
> Hello,
>
> We are stuck with a group of users who insist on using MS access
> 2K 9.0 on a
> Win2K workstation as an adhoc query front end to an Oracle
8.1.7.4
> db on Sun.
>
> The problem is that their queries run OK when executed from
> sqlplus directly
> against Oracle, but are terrible when executed from access. This
> is because
> access has tables linked to the oracle tables, and access insists
> on downloading
> all the data, performing the joins and where clause filters on the
> localworkstation.
>
> I don't know much about access, and don't want to; however, this
> has been dumped
> on us, so I am hoping that someone has experienced the same
> problem and found a
> solution. No, we can't dump access, and use something different;
> for reasons
> beyond our control (management), we have to make this work.
>
> I think the solution is to somehow force the query to be processed
> on the Oracle
> machine, and return only the result set. We have tried the access
> "passthrough"option, but I believe that fails due to the newer
> ansi syntax used by access.
> (OUTER JOIN, INNER JOIN, etc.) The users insist on using
access's
> gui query
> generator.
>
> Has anyone found a solution to this? Is there a good whitepaper
> somewhere like,
> "Using Access as a Front-End Query Tool to Oracle?" (I will
search
> google)
> Thanks to all who have read this far,
> More thanks to any responders,
> Most thanks for any helpful advice
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: becker.bill_at_marshfieldclinic.org
>
> 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.net
> --
> Author:
> INET: dgoulet_at_vicr.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.net
-- 
Author: 
  INET: rabbit_at_emirates.net.ae

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.net
-- 
Author: 
  INET: Jared.Still_at_radisys.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).