Skip to Content
avatar image
Former Member

Reseting password of DDIC in SAP (SQL Database)

Hi

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

Regards

Nilanchal

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 10:01 AM

    Hi Nilanchal,

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

    Regards

    Ashok

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 10:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 20, 2008 at 12:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 03:21 AM

    Hi,

    DDIC can be changed with sql management.

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2008 at 03:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded