AS/400 >> AS400 user lists

by jedbeer » Sat, 17 Dec 2005 03:01:21 GMT

My dept have just inherited an ancient as400
We are eventually going to be running Fiserv on a new Iseries server
and becuase of this my collegues and I have been on the basic as400 ops

My main area of concern up until now has always been unix of varying

My question is one of those "oh my goodness RTFM" questions but anyway

How do I get a list of user accounts on the server , i have stumbled
across it by accident before via menu but cannot for the life of me
find it again.

I need to find user accounts with admin priviliges as our "secadm"
account is locked out

Isn't that clever


AS/400 >> AS400 user lists

by Jonas Temple » Sat, 17 Dec 2005 03:50:00 GMT

>From an O/400 command line type and enter:


AS/400 >> AS400 user lists

by Marc Rauzier » Sat, 17 Dec 2005 03:57:32 GMT

racontait dans

DSPUSRPRF command is for you.

Are you talking about the QSECOFR user profile ? If yes, its password
can be reset to the default value with a manual IPL and the right
option in the right menu (Work with DST menu, Work with system security
and so on ...).
But, of course, you need the password of the DST user profiles :-)
Note that DST user profiles exist starting at V5R1.

Cordialement/Best regards
Marc Rauzier

AS/400 >> AS400 user lists

by jedbeer » Fri, 23 Dec 2005 00:39:27 GMT

Or even wrksplf *ALL will give me a list of sorts

These as400 things are great !!!

AS/400 >> AS400 user lists

by Elvis » Fri, 23 Dec 2005 01:56:50 GMT

Don't forget that iSeries has prompting support so hit F4 on any
command you're using to see the parameters. There is also very good
online help by hitting F1 on any command or parameter.
Once you prompt the command you can hit F9 to see all parameters.

Have fun learning it.

AS/400 >> AS400 user lists

by Chris Pando » Fri, 23 Dec 2005 02:09:44 GMT

[ who has admin? ]


This puts information about all user profiles into an outfile. You may
want the
outfile to live in QGPL or a development library.

The field UPSPAU contains all special authorites (this is a 150
field containing 10 characer special values). You're looking for
and *ALLOBJ.


Similar Threads

1. AS400 users list - Does anyone know where to obtain one. - AS/400

2. Print a list of users sign-ons?


Is there a way to Print a list of particular users sign-ons for a
periode from 1/1/09 to 30/6/09?

How can i do this?

4v5 realease.


3. list of audited users - AS/400

4. List of users connected to DB2 UDB database

Hi everybody,
How to get the list of all users/clients who are connected to my DB2
UDB database v 8.2 server in RHEL?
Please help me out...

5. user list

6. get a list of all users in db2

is there a way (script or command) to get a list of all existing db2-users?
Our system: Windows 2000 server and UDB 7.2 / 8.2
Is there also a way to get the same information for a database running on
thanks for all hints,

7. obtaining authority to run list applications - ordinary users

8. listing user created stored procedures


What SQL would I need to list all user created ( non-system) Stored
procedures,along with it's schemar owner.

db2 8.4