Skip to Content
avatar image
Former Member

need info......Urgent

Hi everyone.

Could any one tell me show to change PASSCODE in USR02 table.

what is the SQL command.

Thank you

Kiran Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 01, 2007 at 09:02 AM

    Hello Kiran,

    Step 1:

    SQLPLUS '/ AS SYSDBA'

    Step 2:

    Export the Entire USR02 table using R3trans (Backup: just incase you need to revert it back to original)

    Step 3:

    SQL> SELECT BNAME, BCODE, MANDT FROM SAP<SID>.USR02 WHERE BNAME=<username> AND MANDT=<client>;

    Here

    MANDT=<client number>

    BNAME=<username>

    (MANDT & BNAME Who's password you already know.)

    The above query will fecth you a single record, Note down the BCODE & BNAME value string.

    Step4:

    SQL> UPDATE SAP<SID>.USR02 SET BCODE='<STRING you noted above>' WHERE BNAME='<username you noted above>' AND MANDT=<Target Client>;

    Step 5:

    SQL> COMMIT;

    Please note:

    The username MUST be SAME in both the queries.

    The password in the target client will be same as source client.

    Regards,

    Ammey Kesarkar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 09:08 PM

    hi everyone..

    i followed the steps mentioned above..i am still not able to change the password

    from the database level.

    could anyone help with this..is there any other way to do this..

    Thank you.

    Kiran Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2007 at 03:37 PM

    hi ammey

    well ammey that was quiet helpful..that actually works..(thank you)

    but tell me tell u what i am trying to do..i am trying to change the password

    of the SAP* and other users password from the DB level..

    not to the target client as you mentioned..

    like resetting the password from the DB level..

    waiting for your response..

    Thank you.

    Kiran Kumar.

    Add comment
    10|10000 characters needed characters exceeded

    • You also posted a dev trace file. I do not see the relation between changing password and the fact that your SAP system is down. Please explain why you see a relation between those 2.

      unless you are trying to change an DB user password, not a SAP password.

      anyways, for SAP system being down, you should open a new topic and also supply contents from dev_w0