For each HANA database that will be monitored, create a monitoring user with the following SQL
create user <Monitoring user> <Monitoring User Password> no force_first_password_change;
alter user <Monitoring user> DISABLE PASSWORD LIFETIME;
grant MONITORING to <Monitoring user>
Note:
Option 'no force_first_password_change' - the password does not need to be changed on the first time login
Option 'DISABLE PASSWORD LIFETIME' - this is considered as a 'technical user', hence it is exempted from changing the password as specified in the parameter 'maximum_password_lifetime'.
MONITORING Role (extract from Security Guide)
Note that for MDC (multi-tenant), the user should be created in the SYSTEMDB and for each tenant database that will be registered in IT-Conductor.
Add Comment