ITPub博客

首页 > 数字化转型 > ERP > Forgot Password for user id SAP*

Forgot Password for user id SAP*

原创 ERP 作者:crispwqh 时间:2007-08-24 16:14:56 0 删除 编辑

First make sure the profile includes the parameter: login/no_automatic_user_sapstar = 0, which means in a client, user sap* will be created automatically if there is no user sap* in this client.

Then delete the user sap* from the user table in sqlplus in command environment, the commands are as following:

C:>set ORACLE_SID = S01

C:>sqlplus /nolog

SQL*Plus: Release 9.0.1.0.1 - Production on 星期三 1 12 19:42:08 2005

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba

Connected.

SQL> select bname, mandt from sapsr3.usr02 where bname=’SAP*’ and mandt=’800’;

//***SAPR3.usr02 if R/3****//

BNAME

---------------------------------------------------------------

MANDT

------------------------------------------

SAP*

800

SQL> delete from sapsr3.usr02 where bname=’SAP*’ and mandt=’800’;

One row is deleted

SQL>exit.

OK, now the user SAP* will be created with password ‘PASS’.

[@more@]

Forgot Password for user id SAP*

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8433094/viewspace-965568/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    12
  • 访问量
    5452