Changing Passwords of the Database Standard Users

The following section provides information on the database standard users, whose passwords you need to change. The users are as follows:

Database Standard Users

User

Function

Command Used to Change Password or Profile

<SID>OPR

SAP system administrator

· CHGPWD

·  CHGUSRPRF

<SID>OFR

SAP system superuser

· CHGPWD

· CHGUSRPRF

<SID><nn>

User that runs the work processes

· CHGUSRPRF

Procedure

Change the initial passwords of <SID>OFR and <SID>OPR to protect your system against unwanted access.

To change the passwords for <SID>OFR and <SID>OPR, proceed as follows:

...

       1.      Sign on to the database server as user <SID>OFR or <SID>OPR.

       2.      In the command line, enter the following command:

CHGPWD

       3.      Enter the old and new passwords.

       4.      If you want to change the user profile, enter the following command:

CHGUSRPRF

If you are using distributed directories on multiple iSeries systems using /QFileSvr.400, you must use the same passwords on all iSeries systems for each of the users <SID>OPR, <SID>OFR, and <SID><nn>.

On iSeries, the only user profiles apart from <SID>OFR that are allowed to access database library R3<SID>DATA are the profiles R3SERVER and <SID><nn>. You cannot sign on with these user profiles.