cancel
Showing results for 
Search instead for 
Did you mean: 

All users locked in NSP system - how can I unlock

Former Member
0 Kudos

Dear all

I have the NSP system (ABAP version sneak preview sp8 with ABAP webdynpro) installed, but unfortunally I have locked SAP*, DDIC and BCUSER in the system - are there any other predefined user that I can use for accessing the system (It is up and running) to get in the SU01 transaction to unlock these users?

Or do I need to go to the MaxDB and do some trick on the USR02 database?

If yes: I have tryed to use the SQL tools with no lock... - but please advice me if this is the right way

Please help me out

Lars

Accepted Solutions (1)

Accepted Solutions (1)

athavanraja
Active Contributor
0 Kudos

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

If all the users are locked, they can be unlocked by

a) GO to command prompt type tp unlocksys <SID> pf=//usr/sap/trans/bin/TP_DOMAIN_<SID>.pfl;

b) or else try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;

this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

c) You can delete sap*

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

<b>After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).</b>

regards,

kanthi

Former Member
0 Kudos

Hi

You can unlock the users by going to the database level.

Refer this query:

Update <schema-owner>.USR02 SET UFLAG = 0 WHERE MANDT='<client-no.>' and BNAME='<user-name'

If UFLAG in USR02 table is 0 then the user is locked and if it is 64 then the user is unlocked.MANDT is the client no.

Also what u can do is..you can reset the password for the master user SAP*.

From the table USR02 you will have to delete the row which is having SAP* depeding on your client.

For that you need to run the delete query.

<b>Note:</b>

Check parameter login/no_automatic_user_sapstar.

Below are the 2 possibilites.

0: Automatic user SAP* is permitted

1: Automatic user SAP* is deactivated.

After changing the parameter you will need to restart the application.

Better to go for the unlock option. Once you unlock the DDIC user u can then unlock SAP* as well by using SU01.

This should solve your problem.

Regards

Sumit Jain

[reward with points if useful]