× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2016

Re: ODBC traffic

Sure that's a simple option...

Works right up till the IBM i gets replaced as being outdated for not
having the Excel integration and/or too expensive since a developer has to
be involved for everything.

Charles

On Wed, Apr 13, 2016 at 12:13 PM, Monnier, Gary <Gary.Monnier@xxxxxxxxx>
wrote:

The really simple option is to not allow ODBC/JDBC/OLEDB connections from
spreadsheets.

A user obliterating a critical table is what spawned PowerTech's exit
point technology. A user utilized Excel to upload, if memory serves, the
chart of accounts. They then eliminated everything they didn't want, made
some changes and downloaded to (at the time) the AS/400.

You can always have the developers write a client-side extract program
that creates a spreadsheet.

Thanks,

Gary Monnier

IT Software Engineer CSM, CSPO

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael Schutte
Sent: Wednesday, April 13, 2016 6:14 AM
To: Midrange Systems Technical Discussion
Subject: Re: ODBC traffic

Somehow you guys think I'm disagreeing with you. I'm not, just pointing
it out as an option.

As this being an option, and you don't want the user to change the
connection or add a new connection, etc. The network team (or people in
charge of windows) can set up group rules to keep the users out of
administration tools. This goes for ODBC connections, DNS-less connections,
etc (maybe not JDBC connections).

So again, the option isn't totally invalid. It's just a different way of
doing it. Different point of view.

On Wed, Apr 13, 2016 at 8:41 AM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

Particularly when it is so easy to defeat without anyone knowing about
it.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Michael Schutte <mschutte369@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Michael Schutte <mschutte369@xxxxxxxxx>
Date: 04/13/2016 08:26AM
Subject: Re: ODBC traffic


Then you fire them. It was just an option. In all seriousness who in
their right mind would want to go around to all company pcs and make
that change.

On Wed, Apr 13, 2016 at 7:43 AM, Mark Murphy/STAR BASE Consulting Inc.
< mmurphy@xxxxxxxxxxxxxxx> wrote:

Until the user googles it and finds that option and unchecks it.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Michael Schutte <mschutte369@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Michael Schutte <mschutte369@xxxxxxxxx>
Date: 04/12/2016 05:09PM
Subject: Re: ODBC traffic


In the windows ODBC connection, find the option that says "SELECT"
statements only. This would be a by user basis.

On Tue, Apr 12, 2016 at 3:44 PM, Charles Wilt
<charles.wilt@xxxxxxxxx>
wrote:

The only way to do this would be on the IBM i side.

Either
1) Using object security, make sure the users only have *USE
authority
the
data.
2) Spend $$$ for a package of exit point programs to lock down
what's allowed.
3) roll-your-own #2

An example of #2
http://www.helpsystems.com/powertech/products/network-security



On Tue, Apr 12, 2016 at 3:16 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

HI We have some users who use ODBC connection in Excel to look
at IBS
data
on the IBM i.

Now I am getting more requests for this.

I never liked this. Now I want to ensure that this can be one
way
traffic
only (read only). How can I ensure this. Secondly, I noticed
that all
users
with green screen get icons of the Windows for IBM ISeries
access. In
these
Icons are also links for sending and receiving data with IBM i.

I don't like this either. We have a few users on green although
most
not.

Can I remove these icons globally? Or has to be one by one.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.