Which system privileges are required for administering tenant databases when connected to the system database?

When administering tenant databases from the system database in SAP HANA, certain system privileges are required to manage and monitor operations effectively. The correct answers are:

DATABASE ADMIN (B): This privilege is essential for performing administrative tasks across different tenant databases. It includes capabilities such as creating, dropping, starting, and stopping tenant databases, which are crucial for overall database administration.

MONITOR ADMIN (D): The MONITOR ADMIN privilege allows users to view performance and monitoring data across tenant databases. This is vital for maintaining the health and performance of the SAP HANA system, providing access to critical monitoring tools and dashboards. While BACKUP ADMIN (A) is also a significant privilege, it is more focused on backup and recovery tasks specifically, and DATA ADMIN (C) involves data handling and database operation privileges that are more granular and not necessarily required for broad administrative actions.

References= These privileges are discussed in SAP HANA administration guides, focusing on system administration and security practices, particularly in multi-tenant database environments.

User Management