Reset SAP* password

[Former Member]

Hi All,

We have need to reset the SAP* password because SAP* (also DDIC) is locked on client 000 and we don't have any other user. We are on MAXDB (we have also SQL Studio) so we have the error "table unknown" when we try to excute the statement SELECT * FROM USR02 or SELECT * FROM SAPECP.USR02, where SAPECP is the owner. Obviously we want to excute the statement DELETE FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'.

How can we proceed on MAXDB?

Reagards

Bob

[markus_doehr2]

As which user are you connecting with the SQLStudio?

--

Markus

[Former Member]

Hi,

look at following forum

-

---

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.

-

---

regards,

kaushal