DDIC Password reset

[Former Member]

Hello All,

How can i reset password of DDIC user of client 000?

I don't have any other user id in same client.

Database MAX DB 7.5

Best regards

amol

[former_member188883 · Accepted solution]

Hi Amol,

You need to set the profile parameter rdisp/login_no_sapstart = 0.

Take SAP r3 restart.

Later connect to SQL studio with schema user.

run the following SQL commands

SQL> select bname from usr02 where mandt='000' and bname='SAP*'

If the user SAP* exists then delete the user with below command

SQL> delete from user02 where mandt='000' and bname='SAP*'

Run the below command to verify whether user deletion was successful.

SQL> select bname from usr02 where mandt='000' and bname='SAP*'

Later login to client 000 with SAP* and password as pass

reset the password for user DDIC with SAP* user.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

i have executed cmd as you have mentioned but its fetching below error

select bname from usr02 where mandt='000' and bname='SAP*'

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(19) Unknown table name:USR02

select bname from usr02 where mandt='000' and bname='SAP*'

[Former Member · Accepted solution]

Please try...

select bname from sap<sid>.usr02 where mandt='000' and bname='SAP*'

OR

select bname from SAPSR3.USR02 where mandt='000' and bname='SAP*'

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hello Rajesh,

I have executed cmd as you have mentioned but helpless

--- Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(19) Unknown table name:USR02

select bname from sapshp.usr02 where mandt='000' and bname='SAP*'

[Former Member · Accepted solution]

Hello,

Typically the tablename would be SAPSCHEMA.USR02

Check your schema name and use it in SQL query..

I am not sure, but check if the name is case sensitive.

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

hello,

i have connected to database with superdba with pwd admin cause it is not allowing me to login from other user

then i have entered query as below

delete from sapr3.shd where bname='SAP*' and mandt='000'

but its is showing that

--- Error

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Base table not found;-4004 POS(19) Unknown table name:USR02

select bname from sapshp.usr02 where mandt='000' and bname='SAP*'

please help

best regards

Amol

[former_member197466 · Accepted solution]

Hi Amol,

Please connect as user SAP<sid> user instead of superdba.

Cheers,

Ivy

[Former Member · Accepted solution]

hello Ivy,

I tried to login with SAPSID but there is error message regarding ODBC drivers & userid & password does not match

Regards

Amol

[Former Member · Accepted solution]

Hello Guys,

for login SAPSID i have changed the password of SAPSID from SUPERDBA user but it leads into the instance down cause of

the database get disconncted from SAP application

please help

[former_member188883 · Accepted solution]

Hi Amol,

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,

Deepak Kori

[Former Member · Accepted solution]

Hello Deepak,

Can you please tell me with which password i have to use to login SAP<SID>,

I tried Installation MASTER password but it is not working,

There must be another password for same.

If i change the password as per the note 25591 my instance get crashed.

please tell me if you have any idea