Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi,
The command is not for resetting the password, but for deleting the SAP* user from the user master data, hence activating the hardcoded SAP* kernel user.
Assuming that your DB schema is SAPSR3, the command will look like this:
db2 "delete from sapsr3.usr02 where bname='SAP*' and mandt='111'";
Regards,
LEH
| | | ---------------Original Message---------------
From: mahmoud younis
Sent: Friday, October 21, 2011 9:14 AM
Subject: How to Reset SAP User Password From OS/ Database Level
Dear all,
Can anyone tell me with the right command to execute to reset password of sap* of client 111 or 000?
database ID: SOLMAN
I have run the following command but still receive errors as below :
C:\Documents and Settings\soladm>db2 select 111, SAP*, UFLAG from SAPSR3.USR02
SQL1328N An implicit connection attempt failed. The database alias name or
database name "SOL" was not found in the local database directory.
SQLSTATE=42705
thanks in advance
Mahmoud |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Lars-Erik Hallsten
SAP Basis Top Contributor
Contributed the most posts in a group for a month to earn a Silver Achievement Popular White Papers
In the Spotlight   _.____.__ |
