on 05-07-2007 11:26 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.