SAP HANA Data Source Spectrum Reports¶
The reports for All User and Admin Count, User Privilege Report, and User Granted Role and Table Count can be generated for the SAP HANA data sources.
The following permissions are required for the following SAP HANA objects:
- select on sys.granted_privileges
- select on sys.users
- select on sys.granted_roles
- select on sys.tables
- GRANT CATALOG READ TO
<username>; - GRANT MONITORING TO
<username>;
These permissions are necessary for the SQL queries in the fetch_report methods of the UserPrivilegeReport, UserGrantedRoleAndTableCount, and AllUserAndAdminCount classes. The queries access system catalogs and views to retrieve user, role, and table information. These reports are explained in detail below.
All User and Admin Count¶
The report provides a summary of the number of admin and non-admin user accounts in a SAP HANA database, along with details about the data source and a timestamp indicating when the data was recorded. It is useful for assessing the distribution of administrative and non-administrative users within the database.
User Privilege Report¶
The report contains information about user accounts in a SAP HANA database, including their system IDs, table counts, group roles, last login times, and timestamps related to SQL risk assessments. It is useful for managing and auditing database user activity and roles.
User Granted Role and Table Count¶
The report provides information about different SAP HANA database users, including the number of roles granted to each user and the count of tables they have access to. It helps in understanding user privileges and the extent of their access within the database.
