on 03-02-2012 8:39 AM
Hello All,
How can i reset password of DDIC user of client 000?
I don't have any other user id in same client.
Database MAX DB 7.5
Best regards
amol
Hi Amol,
You need to set the profile parameter rdisp/login_no_sapstart = 0.
Take SAP r3 restart.
Later connect to SQL studio with schema user.
run the following SQL commands
SQL> select bname from usr02 where mandt='000' and bname='SAP*'
If the user SAP* exists then delete the user with below command
SQL> delete from user02 where mandt='000' and bname='SAP*'
Run the below command to verify whether user deletion was successful.
SQL> select bname from usr02 where mandt='000' and bname='SAP*'
Later login to client 000 with SAP* and password as pass
reset the password for user DDIC with SAP* user.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
i have executed cmd as you have mentioned but its fetching below error
select bname from usr02 where mandt='000' and bname='SAP*'
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Base table not found;-4004 POS(19) Unknown table name:USR02
select bname from usr02 where mandt='000' and bname='SAP*'
hello,
i have connected to database with superdba with pwd admin cause it is not allowing me to login from other user
then i have entered query as below
delete from sapr3.shd where bname='SAP*' and mandt='000'
but its is showing that
--- Error
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
Base table not found;-4004 POS(19) Unknown table name:USR02
select bname from sapshp.usr02 where mandt='000' and bname='SAP*'
please help
best regards
Amol
Hi Amol,
In MaxDB Version 7.5 and higher you can use the "SQLStudio" or the command
line tool "sqlcli" to run the SQL statement, if you are logged on to the OS
as <sid>adm or user in the group sdba:
sqlcli -d <Database name> -u sap<sid>,<Password>
<enter>
"delete from usr02 where mandt='<Client>' and bname='SAP*'"
You could run this SQL statement as schema user - SAP<SID> or SAPR3
After you delete the user in the Database level, please restart the
Application server and you can then logon to the system again with
the SAP* user and the password PASS.
Please see the SAP note 2383 for description of "super user" SAP*!!
Create a super user, allocate it to the SUPER group, and assign it the
SAP_ALL or S_A.SYSTEM authorization profile.
Then maintain the SAP* user and assign it a password.
Hint:
It is sufficient to temporarily set the login/no_automatic_user_sapstar
parameter to the value 0 on the application server < SAP note 68048>.
This application server should be restarted after the value of the profile
parameter was changed.
And you try to log on to this application server as user 000/SAP*/PASS.
SAP strongly recommends that you reset the profile parameter login/no_automatic_user_sapstar to value 1 afterwards.
Regards,
Deepak Kori
Hello Deepak,
Can you please tell me with which password i have to use to login SAP<SID>,
I tried Installation MASTER password but it is not working,
There must be another password for same.
If i change the password as per the note 25591 my instance get crashed.
please tell me if you have any idea
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.