SAP* password reset query in MAXDB

[satishjagan1279]

Hi,

Can you please tell me the steps how to reset the SAP * password in MAX DB database environment.

Thanks and Regards,

Satish

[former_member229109 · Accepted solution]

Hello Satish,

-> What version of the database you have?

Please see the SAP notes 68048 and 2383.

In MaxDB Version 7.5 and higher you can use the "SQLStudio" or the command

line tool "sqlcli" to run the SQL statement, if you are logged on to the OS

as <sid>adm or user in the group sdba:

sqlcli -d <Database name> -u sap<sid>,<Password>

<enter>

"delete from usr02 where mandt='<Client>' and bname='SAP*'"

< You could run this SQL statement as schema user - SAP<SID> or

SAPR3. >

After you delete the user in the Database level, please restart the

Application server and you can then logon to the system again with

the SAP* user and the password PASS.

Please see the SAP note 2383 for description of "super user" SAP*!!

Create a super user, allocate it to the SUPER group, and assign it the

SAP_ALL or S_A.SYSTEM authorization profile.

Then maintain the SAP* user and assign it a password.

Hint:

It is sufficient to temporarily set the login/no_automatic_user_sapstar

parameter to the value 0 on the application server < SAP note 68048>.

This application server should be restarted after the value of the profile

parameter was changed.

And you try to log on to this application server as user 000/SAP*/PASS.

SAP strongly recommends that you reset the profile parameter login/no_automatic_user_sapstar to value 1 afterwards.

Thank you and best regards, Natalia Khlopina

[satishjagan1279 · Accepted solution]

Thanks for your support and help!!!

Regards,

satish

[Former Member · Accepted solution]

Hi Natalia,

Pardon my question, I am not familiar with SAP nor MySQL/MaxDB. I got a SAP environment from another company and I need to login to the system but do not have any username or passwords (like mentioned above), but it is on a Windows 2003 server.

A search fro the sqlcli file on the harddrive returns no results, in which folder do I need to run the script?

I am not sure what you mean with '-u sap<sid>,<Password>', what would the actual string be? Like I said, I do not have any usernames or passwords.

[former_member229109 · Accepted solution]

Hello AdriaanDavel,

please create another thread for your issue.

This one is already closed.

-> As SAP customer => create the SAP message and get SAP support.

-> If you have SAP system => What version of your system and what database are you using?

Regards, Natalia Khlopina

[Former Member]

Hello Satish,

which User do you mean exactly? The SAP* User in the SAP-System to logon via

SAPGUI? Or do you mean the DBA User SAPR3 or SAP-SID>?

If you mean the User SAP* this is not a database user and you use the SAP-Transaction. I don't know exactly if you can use transaction SU01.

The Database User SAPR3 or SAP<SID> password can be changed with note <a href="https://service.sap.com/sap/support/notes/25591">25591</a>

Regards, Christiane Hienger

[satishjagan1279]

Hi,

Thanks for your reply.I want to reset the SAP user id SAP* at the database level,since i dont have any user id tp login in client 000 for support pack upgrade.I used to reset the SAP user id SAP* in SQL server DB.But in MAXDB we dont know how to do it.

Regards,

satish