In case of an authentication failure, Check this link. Try and confirm the system user is accessible : log to the database using SYSTEM USER Check system user status : Check user status Here are the step to unlock the SYSTEM user normallyĪLTER USER SYSTEM RESET CONNECT ATTEMPTS ALTER USER SYSTEM ACTIVATE USER NOW GRANT INIFILE TO USERMANAGER - To be able to reuse the same password for a user: How to update password with same old password GRANT USER ADMIN TO USERMANAGER - To be able to unlock a user Here is an exemple of a standby user to unlocked any user, SYSTEM USER includedĬREATE USER USERMANAGER PASSWORD Manager01 NO FORCE_FIRST_PASSWORD_CHANGE ĪLTER USER USERMANAGER DISABLE PASSWORD LIFETIME ĪLTER USER USERMANAGER RESET CONNECT ATTEMPTS ĪLTER USER USERMANAGER ACTIVATE USER NOW The solution requires stopping the database and business services. Fortunately, a de-activated system user can be reinitialized but at a huge cost, especially in a production environment. "USER ADMIN" privilege is required to unlock any sap hana user, SYSTEM user included. Note: you may be in a trickier situation if none of your users have "USER ADMIN" privilege. This solution is simple and done without any service disruption. Any active sap hana standard user with the "USER ADMIN" privilege can effectively precede the activation. Therefore you will have to reactivate the system user. You will need to use the system user at one stage for sap hana upgrade or migration.
This is a common situation when many people are using the system user. The system user can also be locked due to other reasons such as too many connection attempts with the wrong password. In that case, the locking procedure is controlled and done manually. It could be locked because it is advised to disable the sap hana system user for security purposes. The hana system user can be disabled or locked for various reasons. How to activate or unlock the system user in sap hana?
Refresh data from another tenant database.
0 kommentar(er)
