cancel
Showing results for 
Search instead for 
Did you mean: 

SAPr3 PAssword change in maxdb

pnagar
Participant
0 Kudos

Dear Experts,

I am using maxdb for content server. I need to change the password for SAPR3 but i am not able to chamge it's password using dbmcli while connection as user control & superdba.

Please suggest how to achieve it.

View Entire Topic
VivekSahu
Advisor
Advisor

Hi Prashant,

Without error details or your database version, it's difficult for anyone to respond your query.

Anyways, I can share you some good SAP Notes, which includes password change related some troubleshooting steps :
1542818 - Changing DBM users
2541562 - Resetting passwords as of SAP MaxDB 7.9.09.06
2120775 - Overview note: SAP MaxDB user/password changes

Hope this helps.

Best Regards,
Vivek Sahu

pnagar
Participant
0 Kudos

Dear viveksahu.2011

Getting below error while changing SAPR3 password with user control also mh database version is 7.9.08.23

VivekSahu
Advisor
Advisor
0 Kudos

Hello pnagar ,

I think you should use SAPR3 user only to change the password.

sql_connect SAPR3,<old_password> 
sql_execute ALTER PASSWORD <old_password> to <new_password>

Best Regards,
Vivek Sahu

pnagar
Participant
0 Kudos

Dear Vivek Sahu,

But i am not able to connect to dbmcli via SAPR3, getting below error.\

former_member188065
Participant
0 Kudos

That's because SAPR3 is the DB schema User and no DB admin (superdba, control)

Jiajia
Advisor
Advisor
0 Kudos

To change password for SAPR3 user, please refer to below details

  • Changing the DBA user password
    The database must have the operational state ONLINE.
    You can change the password of a DBA user with Database Studio.


    Database Studio
    The DBA user password is changed by the database administrator itself:
    Log onto the database as the database system administrator (for example, SUPERDBA) using Database Studio. Execute the following SQL statement:
    ALTER PASSWORD <DBA_user> <new_password>
    The DBA user password is changed by the DBA itself:
    Log onto the database as the affected DBA user (for example, SAPR3) using the database studio. Execute the following SQL statement:
    ALTER PASSWORD <old_password> to <new_password>

Best regards,
Jiajia