cancel
Showing results for 
Search instead for 
Did you mean: 

Changing the Password of SAP*

Former Member
0 Kudos

hI ,

I forgot my SAP * password now I want to delete it from DB level

Database is MSSQL 2005 .Guide me with your detailed procedure

Stephen

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear Friend

You can try:

1. sqlcmd -U <dbusername> -P <dbpass>

2. use <database>

3. delete form usr02 where bname='SAP*'

shailesh

Former Member
0 Kudos

Hey Steve

In your Query session in 2005 just just the following query:

delete from USR02 where MANDT = '000' and BNAME = 'SAP*'

This will change the SAP* password back to the default.

Phil

Former Member
0 Kudos

Hey Guys,

I already tried the described steps (also in other topics) several times.

I'm using SAP ERP ECC 6.0 with mssql-server.

sql>use <database>;

is ok.

but

sql>delete from USR02 where MANDT = '000' and BNAME = 'SAP*';

doesn't work. It says: Invalid object name 'USR02'.

I also tried SAP<sid>.usr02, lower and uppercase letters, different values for mandt, DDIC instead of SAP* and I added login/no_automatic_user_sapstar = 0 to the profile with restart of the sap-system after saving. BUT nothing works!

Any Ideas?

Thanks a lot.

Lena

clas_hortien
Active Contributor
0 Kudos

Hi,

you have to switch into the schema first:

use <SID> -- uppercase SID

setuser '<sid>' -- lowercase SID e.g. 'prd'

Then you can delete from the table. Alternativly you can

run the delete with

DELETE FROM PRD.prd.USR02 WHERE ....

The first part of the identifier is the DB, the second the schema and the last part is the table.

Best regards

Clas

Former Member
0 Kudos

Thank you for the fast and very helpful answer.

No it works! Thanks again!

Best regards,

Lena

Former Member
0 Kudos

Hello Lena,

Se38 > Creta a program

&----


*& Report ZPSWRESET

*&

&----


*& Basis - 10.03.2007 - ikarayaka

*&

&----


REPORT ZPSWRESET_V1.

Tables: usr02, t000.

data: passwd like usr02-bcode.

parameters: user like usr02-bname.

select single * from usr02 where bname = user.

if sy-subrc <> 0.

write: / user, 'user does not exist!'. exit.

endif.

passwd = usr02-bcode.

clear usr02.

write: / 'The password of', user, 'updated in client:'.

select * from t000 where mandt <> '066' and mandt <> sy-mandt.

select * from usr02 client specified where mandt = t000-mandt and

bname = user.

write: / usr02-mandt.

usr02-bcode = passwd.

usr02-ltime = sy-uzeit.

usr02-bcda1 = usr02-bcda2 = usr02-bcda3 = sy-datum.

usr02-bcda4 = usr02-bcda5 = sy-datum.

usr02-UFLAG = ''. "change to the target client

update usr02 client specified.

endselect.

endselect.

//////////////

Changing the Password of SAP* ( all client )

Regards

ismail KARAYAKA

Former Member
0 Kudos

thanks buddy

I want to do it from SQL 2005 management studio.Give your guidance with steps..

kishore_soma
Active Participant
0 Kudos

Dera Stephen

The simple thins is go to the Table USR02 from the SQL entrepirse manger, browse it and delete the column with the Bname as SAP* and MANDT =<client no.>. then restart the SAP and Database.

Then you can login to that client using SAP* and the password will be pass.

(if the sap* or DDIC User master records are not found in the database then the SAP gets the password from the Kernel)

<u><i><b>But this is not recommended everytime</b></i></u>

Regards,

Kishore

Former Member
0 Kudos

Stephen,

Which client please? Are you unable to logon as another user - DDIC for example - and use that to change the password?

You can delete SAP* from the database with :

DELETE FROM USR02 WHERE BNAME='SAP*' AND MANDT='000';

But this may not clear the lock if the user ID is locked. Also check to make sure that the profile parameter "login/no_automatic_user_sapstar" is set to 0.

Cheers,

Tim

Former Member
0 Kudos

You can try:

1. sqlcmd -U <dbusername> -P <dbpass>

2. use <database>

3. delete form usr02 where bname='SAP*'

I guess you should use 'GO' after every sqlcmd command. Don't have any SQL Server DB right now to check it out.

Regs,

FS