Not able to open SQL console with admin right in SAP Hana Cloud DB instance under DBADMIN user

[minjie_lao]

Hi,

I created a HANA DB instance on BTP.

I assume DBADMIN should be most powerful account within my instance, because it's the first user created along with DB instance created.

But seems DBADMIN user is not able to open the SQL console with admin right in SAP Hana Cloud?

I am not able to grant the HDI container permission to user without this option.

[Vitaliy-R]

Do you right-click on your HDI container (this is where SQL Console (Admin)) should be visible, or on the DBADMIN user of your DB? It is not visible on the screenshot.

[Vitaliy-R]

As well what kind of environment you created your HANA Cloud DB in: in CloudFoundry, or the new multi-environment? You won't see HDI containers for the later in DBX.

[Cocquerel · Accepted solution]

The option "Open SQL Console (Admin)" is only available for HDI Containers and the prerequisite is to be member of the space with developer role. That's not the case of DBADMIN user.

[minjie_lao · Accepted solution]

thanks so much for the guidance!