Entering content frameProcedure documentation Changing Database User Passwords  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Oracle to display and change the password of database users, such as SAPR3 or SAP<SAPSID> . You can do this with the SAPDBA menus, as described here, or with the SAPDBA command alter user.

You can also display information about the current operating system and database users with the SAPDBA option User and Security. SAPDBA tells you if the database user passwords are still set to the default values.

Caution

Do not leave the passwords for the database user set to the default values.

You can also display the roles of the default users SYS , SYSTEM , OPS$ORAC11 and SAPR3 . The users SAPR3 and OPS$ORAC11 must not have a DBA role, but SYS and SYSTEM must have the DBA role.

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

Procedure

  1. Choose User and security ® Change password.
  2. Select Password entering mode, either invisible or visible.

    3. SAP displays the default user, SAPR3.

  3. Enter the User for which you want to change the password.
  4. Choose Change password.
  5. Enter the new password as requested by SAPDBA

The new password must be no longer than eight characters.

Result

SAPDBA stores the new password as follows:

User

Table

Encryption (from Release 4.5B)

SAPR3

"OPS$<ORACLE_SID>ADM".SAPUSER

Stored as SAPR3-CRYPT

SAP<SAPSID>

"OPS$<SAPSID>ADM".SAPUSER

Stored as SAP<SAPSID>-CRYPT

Note

In the case of the SAP<SAPSID> user, <SAPSID> refers to the SAP System ID. For example, if the SAP System ID is C11 , the SAP<SAPSID> user is SAPC11 , stored in the table OPS$C11ADM.SAPUSER . The first character of <SAPSID> must be a letter and there is no distinction between uppercase and lowercase.

Database users other than SAPR3 and SAP<SAPSID> are not stored in SAPUSER database tables.

Leaving content frame