SAP * And ddic user lock analysis and solutions

Source: Internet
Author: User
SAP * And ddic are two default superusers in the SAP system. They will automatically exist in the system after installation. The default password can be specified during installation, after installation, you can also modify it. The two users have the largest permissions and have the sap_all permissions. However, sometimes the system administrator forgets the password or the two users are locked due to multiple incorrect logon attempts. If other users with administrators cannot log on to the system, we only use the following methods:

Delete from usr02 where mandt = '<client>' and bname = 'sap *'

This solution can reset the initial password of the sap * User. Next, we can use the pass initial password to log on to the corresponding client. Next, we can use sap * to unlock the user ddic. From the statement point of view, we deleted all the user information and logon password of sap * from the usr02 table. The usr02 table records the information of all users of the system, so why can we use sap */pass to log on to the system after deletion? This is because sap * is a special user. The user and initial password have been added to the SAP kernel by hardcoded. If the system cannot find sap * In usr02, the user's logon information will be read from the kernel. However, other users are different. If the user is deleted from usr02, the user does not exist.
 
Note that you can log on to sap * only when login/no_automatic_user_sapstar is set to 0. If login/no_automatic_user_sapstar is set to 1, you cannot log on to sap.

Reference: http://www.cnblogs.com/SlashOut/archive/2008/07/05/1236208.html

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.