Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

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)

Image Modified

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.