Which system privilege is required to view roles granted to other users in SAP HANA?

In SAP HANA, the system privilege needed to view roles granted to other users is CATALOG READ. This privilege allows users to access metadata information within the system, which includes the details about roles and their assignments to users. With CATALOG READ, users can query the catalog tables to obtain information regarding user authorizations, roles, and other essential elements of the database schema. This is fundamental for administrative tasks such as auditing and ensuring that users have the appropriate roles assigned to them.

Other privileges like DATA ADMIN and USER ADMIN can grant various permissions related to data management and user management, but they do not specifically allow visibility into the roles assigned to other users or the viewing of role assignments. ROLE MANAGE relates more to the creation and management of roles rather than granting visibility over existing role assignments. The requirement for CATALOG READ is essential for those who need insight into user roles within an organized and secure manner.