Re: Query Lawson security files -- MIDRANGE-L

Jerry

Try this - DSPUSRPRF OUTPUT(*OUTFILE) OUTFILE(YOURLIB/UPOUTF)- then do an EXCEPTION JOIN of that outfile and whatever has the restrictions listed. Join on user profile. Put the outfile first. Something like

select distinct usrprf from yourlib/upoutf exception join lawsonfile on upoutf.upuprf = lawsonfile.usrprf

This will give you all the user profiles that have no restrictions.

If these security classes are not system user profiles, there is probably a file that lists them in Lawson. Find out what it is and substitute the name for "upoutf" above.

HTH
Vern

At 05:30 PM 7/2/2004, you wrote:

For you Lawson users:
I need to compile a list of security classes that have access to a particular form (IC04.1). Lawson maintins security files that contain records of security classes that do NOT have access to a particular form (userexe) as well as a file that shows what security classes cannot do.
I can query these files to get a list of users (security classes) that are
restricted but I cannot get a list of users (security classes) that are NOT
restricted.
Lawson tech support response is:
"Your best bet is to enter an enhancement request or visit with your client account manager for assistance on writing your own custom report. If it's even possible to do what you're trying to do a technical resource may be able to help modify your files to get you what you're looking for. Of course, as you're aware that would be billable. Would you like me to contact your client account manager for you?"
A worthless statement too common for Lawson.
Anyone know this stuff?
Jerry
--
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.