BASIS–SAP預設使用者和預設口令（如何修改忘記預設的sap口令）

lients	000	000	066	066	New Clients
User ID	DDIC	SAP*	SAP*	EarlyWatch	(SAP*)
Pass Word	19920706	06071992	06071992	SUPPORT	pass

 

如何修改忘記預設的sap口令

Oracle 8.1.7 sap 46C

用<SID>adm登入svrmgrlconnect internal/*本句用來，查詢一下，是否有此記錄。正常情況下，顯示: 1 row(s) selected. */select * from sapr3.usr02 where bname='SAP*' and mandt='000';/*刪除此記錄。防止拼錯，最好直接從上一句copy*/delete from sapr3.usr02 where bname='SAP*' and mandt='000';commit;
Oracle 9.2.0 SAP 4.70

<sid>是執行個體名,如PRD，C11等sqlplus /nologconnect / as sysdba*本句用來，查詢一下，是否有此記錄。正常情況下，顯示: 1 row(s) selected. */select * from sap<sid>.usr02 where bname='SAP*' and mandt='000';/*刪除此記錄。防止拼錯，最好直接從上一句copy*/delete from sap<sid>.usr02 where bname='SAP*' and mandt='000';commit;

DB2

<SID> 是資料庫名<sid> 對於4.6C　為　r3 對於4.70　為 <sid>資料庫名（小寫）

db2 => connect to <SID>db2 => select * from sap<sid>.usr02 where bname='SAP*' and mandt='000'1 record(s) selected.

db2 => delete from sap<sid>.usr02 where bname='SAP*' and mandt='000'DB20000I The SQL command completed successfully.db2 => commitDB20000I The SQL command completed successfully.

MS SQL 2000

開啟MS SQL Enterprise Manager, 從菜單[工具]中，選查詢分析器<sid> 46C 是r3 或是　空(沒有的),大夥可以自己測試一下。470是系統名

select * from <sid>.usr02 where BNAME='SAP*' and MANDT='000';delete from <sid>.usr02 where BNAME='SAP*' and MANDT='000';commit;

重新用sap* 口令pass登入就OK了。