on 10-18-2007 11:53 AM
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
Dear Friend
You can try:
1. sqlcmd -U <dbusername> -P <dbpass>
2. use <database>
3. delete form usr02 where bname='SAP*'
shailesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
thanks buddy
I want to do it from SQL 2005 management studio.Give your guidance with steps..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.