Using a logon trigger works until they figure out
that renaming the executable will let them in.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/02/2003 08:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED] 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: [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.net
> --
> Author:
> 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.net
--
Author:
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.net
--
Author:
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).
