|
One easy way is via SQL. Just type in STRSQL and enter the following: delete from zma where MAUSR = 'USERID' where 'USERID' is the user name you want to delete from zma ---MacWheel99@aol.com wrote: > > We have employee turn-over. We add new people to OS/400, SSA Security, User > Menus. We remove former employees from OS/400, but their names stick around > in BPCS 405 CD. > > I wrote a Query off ZMAL03 to list menu support by user, which is a big help > manageing people growth in responsibilities = what menus should they be > connected to, and also in recognizing names of folks who had been taken off > OS/400 security. > > How do I get rid of folks in SYS600 who are no longer with the company? I > have another query off ZSC to chart by application who all has what kind of > clearance & the data shows people gone from OS/400 security, whom I deleted > from BPCS security .... is there some program to reorg BPCS security files, or > is that up to SSA customer to fill the gap? > > Al Macintyre > I wear many hats & one of them is managing security. > +--- > | This is the BPCS Users Mailing List! > | To submit a new message, send your mail to BPCS-L@midrange.com. > | To subscribe to this list send email to BPCS-L-SUB@midrange.com. > | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. > | Questions should be directed to the list owner: dasmussen@aol.com > +--- > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
As an Amazon Associate we earn from qualifying purchases.
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.