Question

求助：IDES4.7中ddic和sap*密码忘记，如何修改，请高手指点一下，谢谢！

不好意思，没说环境，学习用装在笔记本上，32bit，win2003sp1，r3 4.7，ORACLE9.2， database:r3，username:sapr3，client:000中ddic和sap*密码忘记了，如何修改这两个 帐号的密码，请说的详细点（对oracle不熟），请指点，多谢！！！

Answer 1

删除表USR02中bname = 'sap*' and MANDT = '000'的值
对于ECC6以下的版本来说，你就可以用SAP*密码PASS登陆了，但ECC 6不行.

具体oracle操作命令如下：
SQL>CONNECT / AS SYSDBA
SQL>SELECT TABLE_NAME ,OWNER FROM sapr3.usr02 WHERE bname = 'sap*';
TABLE_NAME OWNER------------------------------ ---------------
USR02 SAPR3

SQL>DELETE SAPR3.USR02 WHERE BNAME='SAP*' AND MANDT='000';
SQL>EXIT

用sap*/pass登录后再去更改ddic密码即可。

Answer 2

delete from sapr3.USR02 where BNAME = 'SAP*' AND MANDT = 'Your client number' commit And the sap* password recover to the initial:pass

Answer 3

谢谢！再问一下，我的ddic也是 delete from sapr3.USR02 where BNAME = 'DDIC' AND MANDT = 'Your client number' commit 这样操作么？密码也是pass么？

Answer 4

sqlplus /nolog SQL>connect / as sysdba 然后输入上面的