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 |
|---|---|---|
M_SYSTEM_OVERVIEW | Overview of system status. Monitors the health of the SAP HANA Database (CPU, Memory, File, and so on). | |
M_SERVICE_STATISTICS M_SERVICES | Discovers and monitors status and statistics of the SAP HANA database services. | |
M_VOLUME_FILES | Discovers and monitors SAP HANA files such as log, trace, and data files. |