«
»

SAP Basis

Forgot Password for user id SAP* in client 000

01.24.08 | 28 Comments

Forgot Password for user id SAP* in client 000

You need to log in to client 000 to apply support packages but you forgot your SAP* pasword in client 000 and you don’t know what to do now.

1. You can logon as DDIC and change the SAP* password

2. You can delete the userid, SAP*, from the database, SAP has this userid defined in its kernel (the SAP executable code that sits at the operating system level, i.e., disp+work). When this situation exists, the password defined in the SAP code for SAP* is PASS.

# su – orasid
hostsid:orasid 1> sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 – Production on Thu Jan 24 10:34:20 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> select * from <SchemaOwner>.usr02 where bname=’SAP*’ and mandt=’000′;

Run query to check return. Change Select to Delete and run again.

SQL> delete from <SchemaOwner>.usr02 where bname=’SAP*’ and mandt=’000′;
1 row deleted.
SQL> commit;
Commit complete.

28 Comments

have your say

Add your comment below, or trackback from your own site. Subscribe to these comments.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

:

:


«
»