User roles and privileges for SAP HANA Database

This section describes the user roles and permissions required for monitoring SAP HANA database. The following authorization roles are required for SAP HANA system instance database user:
  • PUBLIC
  • Monitoring

The SAP HANA Database user name must have read permission for the following system tables:

  • M_VOLUME_FILES
  • M_SERVICES
  • M_SERVICE_STATISTICS
  • M_SYSTEM_OVERVIEW
  • M_HOST_INFORMATION

For more more information about system table, see SAP HANA system tables.

In addition, BMC PATROL for SAP HANA has the capability to execute custom SQL based on user criteria and report the following powerful metrics:

  • Execution response time
  • Execution status
  • Number of records measured in the table

To activate these features, you must have read permission for system tables in the custom SQL.

SAP HANA system tables

SAP HANA system tables allow you to query for various information about the system state using SQL commands, and the results appear as tables. BMC PATROL for SAP HANA collects data from the system tables using JDBC connection. 

The following table lists the application classes that are used to collect data from the system tables.

Application class
System tables
Comments

Health (SHM_Health)

M_SYSTEM_OVERVIEW

Overview of system status.

Monitors the health of the SAP HANA Database (CPU, Memory, File, and so on).

Services (SHM_Services)

M_SERVICE_STATISTICS

M_SERVICES

Discovers and monitors status and statistics of the SAP HANA database services.

Files (SHM_Files)

M_VOLUME_FILES

Discovers and monitors SAP HANA files such as log, trace, and data files.
Was this page helpful? Yes No Submitting... Thank you

Comments