SAPr3 PAssword change in maxdb

[pnagar]

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.

[VivekSahu]

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]

Dear viveksahu.2011

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

[VivekSahu]

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]

Dear Vivek Sahu,

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

[former_member188065]

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

[Jiajia]

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