Reseting password of DDIC in SAP (SQL Database)

[Former Member]

Hi

Kindly suggest how to change the DDIC password in MS SQL Database ?

Regards

Nilanchal

[Former Member]

All passwords are encryted in the table. You can only login with sap* to change the password through SAP. only sap* user id can be reset its password by deletion of ID at database level

[Former Member]

Hi,

DDIC can be changed with sql management.

Anil

[debasissahoo]

Hello,

I think in SQL Server Management Studio, you have the option for directly editing the table row. but I'm not sure of the impact of changing the DDIC password directly in the table level. May be the original password will be seen in the table.

But its definitely not a recommended procedure to change the DDIC password by script.

Regards,

Debasis.

[Former Member]

I can able change with SU01

Can you please let me know the script which is to be run from SQL prompt. I know user table is SU02.

Regards

Nilanchal

[Former Member]

Hi Nilanchal,

The user table is USR02.

As your database is SQL Database you have to open SQL Server Management Studio and there you have to run the script.

Regards

Ashok

[Former Member]

Hi Nilanchal,

If you can logon to SAPsystem with user sap* then this can be done using t-code su01

Regards

Ashok