cancel
Showing results for 
Search instead for 
Did you mean: 

sap* user not accessible

Former Member
0 Kudos

Hii guyz,

I did client copy from 001 to a client 800 and created a user with profile sap_all and sap_new. After that i tried to login into 000 or 001 clients with sap* and pass but could not do so. Could anyone plzzz help me.I tried to delete sap* from usr02 in th database level but it gave me error so plzzz guide me....

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Venkatesh,

you did a client copy from 001 to 800. So how can the passwor in the source client(000) get changed? you must hav forgotten it. if you know DDIC password in 000 use it to unlock sap*. If not follow the steps below,

Prerequisite:

profile parameter login/no_automatic_user_sapstar = 0

If this parameter is not 0 then Set the profile parameter login/no_automatic_user_sapstar to 0 then restart SAP.

Now you have to delete sap* from DB:

sqlplus /nolog

connect / as sysdba

DELETE * from sap<sid>.usr02 where bname='sap' and mandt=<your client where sap is locked>;

commit;

(Note: sap<sid> is the owner of sap table, it may be different in your system, you can search it with the following query:

select username from dba_users;)

Now login to your client where sap* is locked, using sap* and password pass. you will be able to login.

Answers (1)

Answers (1)

Former Member
0 Kudos

thakyou bidwan i sorted out the problem.take your points.......