Re: Fw: Rewarding challenge AS/400...

In the accounting field, store the employee number.  Do a DSPUSRPRF to an 
outfile.
Select * from DSPUSRPRF where UPACCD not in (Select empnum from empmast where 
active='Y')




clewis@iquest.net on 09/15/99 08:35:26 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Re: Fw: Rewarding challenge AS/400...

"What ? They are gone ? TWO months ago !!! ???" ;-)

Colin Williams wrote:

> Hands up if you dont delete user profiles when someone leaves the
> company.
>
> >>> -----Original Message-----
> >>> From: Pat Barber [mailto:MBOCEANSIDE@postoffice.worldnet.att.net]
> >>> Sent: Tuesday, September 14, 1999 11:52 PM
> >>> To: MIDRANGE-L@midrange.com
> >>> Subject: Re: Fw: Rewarding challenge AS/400...
> >>>
> >>>
> >>> Dennis D Pearson wrote:
> >>> >
> >>> > Chuck
> >>> >
> >>> > I did a quick look into the alt.2600 newsgroup and found the
> >>> > following reference to userids and password in the FAQ posting.
> >>> >
> >>> > Dennis Pearson
> >>> > -----------------------------------------------------------
> >>> > AS/400
> >>> > ~~~~~~
> >>> > qsecofr         qsecofr         /* master security officer */
> >>> > qsysopr         qsysopr         /* system operator         */
> >>> > qpgmr           qpgmr           /* default programmer      */
> >>>
> >>>
> >>> As I recall, one of the magazines a couple years back, actually had
> >>> some folks try to hack a 400... It was broken down into a group
> >>> of pc gurus, plus a group of 400 bubba's... Neither group made ANY
> >>> headway.... The system was secured using normal methods... They had
> >>> a local attached lan with a firewall... Most didn't even
> >>> get through the
> >>> firewall.. It's not impossible but I suspect, they would
> >>> need a great
> >>> deal of "insider" help to really get to the system.... You don't get
> >>> that
> >>> goverment security rating(I forget the level) by having a
> >>> "hackable"
> >>> OS.... Most of the hacking that we read about is "urban myth" with a
> >>> little hand by the media... Now the "web" is somthing different
> >>> altogether....
> >>>
> >>> Has anybody "ever" had a intruder(other than an insider)
> >>> get to their
> >>> system ???
> >>> +---
> >>> | 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
> >>> +---
> >>>
> +---
> | 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
> +---

+---
| 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
+---


+---
| 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
+---