Re: PC tool to access 400 data

[John Earl <johnearl@xxxxxxxxxxx>]

Bob Clark wrote:

> Yes, I was freaked out a little at first.  Then I got together with a couple 
>of users and
> we ran some tests.  Apparently the users cannot link to any files that they 
>are not
> authorized to.  I feel a little bit better now,  However, I was wondering if 
>there is any
> way to write an ODBC exit program on the AS/400 to limit who can use ODBC for 
>data
> access.  Does anybody know?

Bob,

Yes, this is what exit programs do well.  To stop ODBC you need to plug both 
the DRDA and the
Remote SQL servers (the latter has several functions).    Be aware that if you 
are vulnerable
to ODBC, you are also vulnerable to file Transfer, DDM, remote command, etc, so 
you'll want
exit points to plug those holes too.

jte

(P.S. I'm a vendor of exit point solutions, feel free to call if you'd rather 
just purchase a
solution.)



>
>
> Chuck Lewis wrote:
>
> > YIKES !!!
> >
> > Doesn't that SCARE YOU TO DEATH ???? !!!!
> >
> > Depending on what type of user this is and what data they are getting to, 
>sounds like
> > they have WAY too much authority...
> >
> > Chuck
> >
> > Bob Clark wrote:
> >
> > > Microsoft Access works.  I just became aware that one of my users has 
>figured out
> > > how to update AS/400 data directly using an output table generated from a
> > > Microsoft Access database containing a linked AS/400 table.  He is 
>currently
> > > editing the data directly in the query table but in theory it shouldn't 
>be much
> > > harder to set up a form.
> > >
> > > Ashok Dave wrote:
> > >
> > > > Does anyone know of a PC, maybe GUI based, tool that can be used to
> > > > access and update AS400 data ?
> > > > I know the "400 Group" recently presented seminars on how to do this
> > > > with certain packages but I did not have the need to know then. Now I do
> > > > !
> > > >
> > > > Thanks.
> > > > Ash
> > > >
> > > > ______________________________________________________
> > > > Get Your Private, Free Email at http://www.hotmail.com
> > > > +---
> > > > | This is the Midrange System Mailing List!
> > > > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > > > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to 
>MIDRANGE-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner/operator: 
>david@midrange.com
> > > > +---
> > >
> > >   ------------------------------------------------------------------------
> > >
> > >   Bob Clark <bclark@ussafety.com>
> > >   Programmer/Analyst
> > >   US Safety
> > >
> > >   Bob Clark
> > >   Programmer/Analyst  <bclark@ussafety.com>
> > >   US Safety
> > >   8101 Lenexa Dr.     Work: 913-599-5555 x274
> > >   Lenexa              Fax: 913-599-1703
> > >   Ks                  Netscape Conference Address
> > >   66214               Netscape Conference DLS Server
> > >   USA
> > >   Additional Information:
> > >   Last Name      Clark
> > >   First Name     Bob
> > >   Version        2.1
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator: 
>david@midrange.com
> > +---
>
>   ------------------------------------------------------------
>
>   Bob Clark <bclark@ussafety.com>
>   Programmer/Analyst
>   US Safety
>
>   Bob Clark
>   Programmer/Analyst  <bclark@ussafety.com>
>   US Safety
>   8101 Lenexa Dr.     Work: 913-599-5555 x274
>   Lenexa              Fax: 913-599-1703
>   Ks                  Netscape Conference Address
>   66214               Netscape Conference DLS Server
>   USA
>   Additional Information:
>   Last Name      Clark
>   First Name     Bob
>   Version        2.1



--
John Earl
PowerTech Toolworks
johne@toolnet.com
253-858-7388

Riley Nichole Earl, Born 7/6/98 - 8lb 11oz.  Already an AS/400 fan!
--




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---