How to list all the HANA databases for Multi tenant Databases

In this tutorial I’ll explain How to list all the HANA databases for Multi tenant Databases.

Step 1– Launch SAP HANA Studio and open SQL console .( using SYSTEMDB)

Step 2 – Execute query  ” select * from m_databases “.

Note:

If above query is executed from different user apart from “SYSTEM” then you’ll not get the list of all the tenant databases .

M_DATABASES only shows the current SYSTEMDB.

Solution :

Provide DATABASE ADMIN or DATABASE STOP or DATABASE START privilege to the said user (in SYSTEMDB) then execute :  select * from M_DATABASES again from SYSTEMDB