on 10-08-2009 8:04 AM
Respected Guru's,
we are unable to access user SAP* as the password is not available.
I need to delete user SAP* from database table and restart the server using MSSQL 2005 server.
Please help me to do so, as i am a novice in MSSQL 2005 server.
Regards,
Daya
The command would be
delete from usr02 where bname = 'SAP*' and mandt = <client-number>
After that you need to make sure the system as the profile parameter
login/no_automatic_user_sapstar = 0
set, restart the instance and logon with SAP*.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Markus,
when i executed the below mentioned command
delete from usr02 where bname = 'SAP*' and mandt = '500'
i get the follwoing error
Msg 208, Level 16, State 1, Line 1
Invalid object name 'usr02'.
i have also tried giving the client no without ' ' but i get the same error.
Please help me
Regards
Daya.
Thank you Anindya,
finnally out of your guidence i have reset the password for SAP* password as PASS.
problem was with the case that i have entered. Client and username field should be in caps and schema name should be as it is in system status.
But, when i checked in SU01 user SAP* does not exsist, but i am able to logon.
What's happening?
Regards,
Dayanandan.
This is expected.
Currently you are using SAP* with hardcoded password "pass" from the kernel.
If you want to use your own password then you have to create the user master from su01 for SAP. Once you create user master for SAP and change the password the default password "pass" will be overwritten.
Presently there is no user master record for sap*
>
But, when i checked in SU01 user SAP* does not exsist, but i am able to logon.
> What's happening?
This is expected behaviour.
SAP* is not a real "user", it's hardcoded into the kernel.
Once you log in with that user an SU01 entry will be created to be able to set a password for the user. But it's not a real user and should not be used for administration tasks.
Since that was a security issue with older version; so you should set the parameter login/no_automatic_user_sapstar back to 1 once you're logged in.
Markus
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.