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 “.
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.
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