on 2024 Oct 05 10:40 AM
I have created a new client (787) and performed a local client copy from client 000 using the profile SAP_ALL. After the copy was completed, I am unable to log in with SAP* or DDIC user passwords. Could anyone please guide me through resolving this issue?
I am new to SAP BASIS, and we are running on Windows ECC 6.0 with Sybase DB.
Any help would be appreciated!
Faiyaz
Hi @mmshareef
For SAP*:
- login/no_automatic_user_sapstar must be set to 0
- there must be no sap* user record to use the default password - if there is you need to know the password assigned to the sap* user
Some useful links on the subject
Note 2383 - Documentation: description of "super user" SAP*
Note 68048 - Deactivating the automatic SAP* user
Activating Automatic sap* user
Profile Parameters for Logon and Password (Login Parameters)
I hope this helps
Gavin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
login/no_automatic_user_sapstar need to be disabled to log in as sap*
If a sap* user was created manually then that password is required to log in - the default password will not work
The SQL error is due to the the user executing the SQL command not having sufficient permission at the database level - it's not SAP related
Hi @mmshareef
The link @S_Sriram supplied is comprehensive and the sql is not database dependent. All that will change is the tool you use to connect to the database to run the sql. There should be a Sybase command line utility to connect to the database for this scenario.
The actions you need to take
Perhaps it is appropriate to mention that under normal circumstances you shouldn’t directly update n SAP database.
Gavin
User | Count |
---|---|
62 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.