User Privilege for DamengDB Monitoring

User Privilege for DamengDB Monitoring

To effectively monitor DamengDB in Applications Manager, the Monitor user must be granted the Data Viewer privilege.
To grant this privilege to the newly created user, please follow the steps given below:
  1. Connect to your DamengDB instance using a client such as DMS or a command-line interface like DmSQL.
  2. If you do not have an existing user, run the following SQL command to create a new one. However, if you already have an existing user, please skip this step.
    CREATE USER <username> IDENTIFIED BY "<password>";
    Replace <username> with the desired username and <password> with a secure password for the user.
  3. Grant the Data Viewer privilege to the user by running the following SQL command:
    GRANT SELECT ANY TABLE TO <username>;
    Replace <username> with the desired username.
  4. This will grant the user permission to view data from any table in the database.
  5. You can now use this user profile to add DamengDB monitoring within Applications Manager.