INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Dealers Business System on AS/400

Dealers Business System on AS/400

(OP)
Is there anyone with experience on AS/400, especificaly an aplication called DBS?

RE: Dealers Business System on AS/400

AS/400, yes...DBS, no. I've used Global's software, so I might be somewhat familiar with the processes.

Did you have a question?

Mark

RE: Dealers Business System on AS/400

(OP)
What kind of report should I ask for or where do I need to look to know which users at OS level has superuser administrative rights?

RE: Dealers Business System on AS/400

my guess would be that the software users the IBM security, but could also be like the old JD Edwards World software,, which adds security with in its database configuration. Are you asking "how to sign the AS400",, or how to sign on the DBS.

RE: Dealers Business System on AS/400

The AS400 user that has those rights is the built-in QSECOFR user. There could be other users that have the same rights but QSECOFR is built-in. If you don't know what the passwords are, the only thing I know to do is to contact IBM. They can send someone to reset the QSECOFR password. There may be other ways.

Some machines have never had their QSECOFR password changed which is really stupid. The default password for QSECOFR is QSECOFR.

 

RE: Dealers Business System on AS/400

(OP)
Ok, got it, but how can I see the privilages or rolls of other accounts?
(I'm not the administrator, I'm doing a kind of small auditory on the systems)

RE: Dealers Business System on AS/400

you have to be able to query the file, and print it,, which means you have to know IBM query or get the system administrator to do it for you.. Depending on the level of security established on the AS400,, it could go a deep as what file they are able to use.  If the admin has established "roles",, for them they should be able to tell you that.  

RE: Dealers Business System on AS/400

(OP)
GO SECTOOLS is good for it?

RE: Dealers Business System on AS/400

i never used SECTOOLS but if you have access to that you should be able to run the DSPUSRPRF command.

The command, DSPUSRPRF, has the info regarding the authorities of a user. Type it on a command line.

SECTOOLS may be more useful to you, though. option 9, print profile internals looks interesting.

RE: Dealers Business System on AS/400

(OP)
I need to know which other accounts could have the access rigths of QSECOFR or at lest *ALLOBJ and/or *SECADM.

RE: Dealers Business System on AS/400

Use the DSPUSRPRF command as follows:

CODE

DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(library/file)

That will create a file that can be queried. A field in the file lists the special authorities the profile can have. The field is UPSPAU. It is 150 bytes.
The field can have multiple values.

You can query like this:

CODE

SELECT UPUPRF, UPSPAU FROM DSPUSRPRF
WHERE UPSPAU LIKE '%*ALLOBJ%'       
 

RE: Dealers Business System on AS/400

(OP)
THANKS =)

RE: Dealers Business System on AS/400

You're welcome.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close