User roles and privileges for SAP HANA Database
The SAP HANA Database user name must have read permission for the following system tables:
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.
Overview of system status.
Monitors the health of the SAP HANA Database (CPU, Memory, File, and so on).
Discovers and monitors status and statistics of the SAP HANA database services.
|Discovers and monitors SAP HANA files such as log, trace, and data files.|