Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
dear Lars-Erik,
thanks a lot for your reply
i tried to run the command you suggested but i still receive this error
C:\Documents and Settings\soladm>db2 "delete from SAPSR3.usr02 where bname='SAP*' and mandt='111'";
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1328N An implicit connection attempt failed. The database alias name or
database name "SOL" was not found in the local database directory.
SQLSTATE=42705
is there a problem in my db2 ?
| | | ---------------Original Message---------------
From: Lars-Erik Hallsten
Sent: Saturday, October 22, 2011 11:48 AM
Subject: How to Reset SAP User Password From OS/ Database Level
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 |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight   _.____.__ |
