RE: User Profile Analysis

Oh yeah. Done lots of "SECTOOLS" - but that doesn't allow me to include
our own in house menu security records - therefore my desire for a
program that will give me DSPUSRPRF +.

In the meantime, I am prepping to pull my USRPRF data from the output of
DSPUSRPRF. Jus' kinda hoping that someone will sneak in with a
programmed answer before I get too deep... :-)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, June 07, 2007 12:11 PM
To: Midrange Systems Technical Discussion
Subject: Re: User Profile Analysis

Well, iNav is pretty cool.

You could have an adopted authority program do a DSPUSRPRF to an output
file.
Then you could do all sorts of things with SQL.
select outfile.*,
CASE UPSPAU LIKE '%ALLOBJ%' ...
'Godlike' as Authority
other 'Wimpy' as Authority
endCase
from outfile
That's kind of shoot from the hip.

Have you looked at GO SECTOOLS?

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Turnidge, Dave" <DTurnidge@xxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/07/2007 12:04 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
User Profile Analysis






I have been tasked with writing a user profile analysis program. Before
re-inventing the wheel, I want to find out if there is already one
available that will be a quick-start help. So far, my searches have
proven unfruitful. It appears to take a special talent to put words
together in a way that returns the result set required - and I don't
seem to have that talent...

What I am envisioning is a program that brings up a subfile of user
profiles on the system. It should be able to locate to specific
profiles, and probably should be able to sort by user description as
well as user profile name.

When a user profile is selected, a second screen would come up that
shows all relevant information regarding that user profile, and then
(from a file specific to our company) give a subfile of menu options
that the user has authority for.

This program should also be able to print one or all user profiles and
the menu options that each profile has authority to.

I hoping for at least RPGLE if not SQLLE, and the use of APIs to gather
information would be a bonus (for learning purposes).

Thank you,

Dave