User Groups 2

[kgreer]

This might be the wrong forum to ask this in. I am trying to organize my user profiles on the AS400. I want to be able to put users into certain groups. I don't want the group to have the authority, the only purpose for the group is categoize the users. I want the authority be handle per user base. Also whats the command to create a group.

Thanks

 

[MdnghtPgmr]

kgreer,

You need to read up on Group Profiles. I believe that is the direction you are headed.

HTH,
MdnghtPgmr

 

[Mercury2]

Create a new profile dedicated to be as a group profile then set the newly created group profile to user profile's GRPPRF kwd and keep OWNER(*USRPRF).
hth

Talkturkey is off, long live to Mercury2

 

[MdnghtPgmr]

Mercury2,

I was wondering about that just yesterday! Thanks for the heads up.

MdnghtPgmr

 

[kgreer]

Can you show me some examples?

 

[Mercury2]

kgreer,

e.g. you want to put users of accounting dept into the same group, say ACCOUNT.

Basically this is what I'd do:

1/ Create the group profile ACCOUNT
CRTUSRPRF USRPRF(ACCOUNT) ... GRPPRF(*NONE) ...

2/ Then for each user in accounting dept, update the GRPPRF kwd as follows :
CHGUSRPRF USRPRF(MyUser) ... GRPPRF(ACCOUNT) OWNER(*USRPRF)

 

[kgreer]

OK, I understand now, thanks for the explanation

 

[kgreer]

One more question.....

After I assign each person to a group, can I run some type of report to return each person within a group?

 

[Mercury2]

yes, you can create the report you want with query/400.

1/ DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/QADSPUPB)
2/ Create a QRY400 report over the QTEMP/QADSPUPB file and select records where UPGRPF = 'ACCOUNT' or whatever you put into GRPPRF kwd.

You could wrap up both DSPUSRPRF and RUNQRY in a CL program to submit in batch mode.

 

[kgreer]

Thanks again Mercury2

 

[Rich96]

kgreer - You can also use the AcctCde parameter. I've assigned my profiles a certain number (001) that represent what location they are at, then you can setup a query. I can get you an example if you'd like.

Rich Bateman
American Bank of Texas
select * from Life where Brain is not null

 

[kgreer]

yeah i am always up for some new ideas

 

[Rich96]

i will send you the info tomorrow when i get to work.

Rich Bateman
American Bank of Texas
select * from Life where Brain is not null

 

[arrow483]

Once you have your users in groups, Navigator has a GUI where you can view users by groups.