How to Activate a User created by System SuperUser(_SYS_DI_SU) from SAP HANA Cockpit User Management

[sPatil]

Hi,

In SAP HANA Cockpit User management, when any new user is created by DBADMIN user, then for that new user I am able to see 'Activate/Deactivate' option. But when any user is created by super user (_SYS_DI_SU) and I have logged in as DBADMIN then I am not able to see that 'Activate' option. I also tried ALTER command from DBADMIN SQL window but it's showing me authorization issue.

Kindly guide how to activate any user created by system user '_SYS_DI_SU'.

(Note - We have observed that when we write a schema name in mta.yaml and then build + deploy the MTA project then that schema as a user is getting created in User Management and there its showing created _SYS_DI_SU and it's in deactivate state.)

Thanks in advance.

[HakanHaslaman]

_SYS_DI_SU user is a system user that is used by the HDI to create and manage containers. This user has special privileges and cannot be managed like regular database users.
If you want to activate a user created by _SYS_DI_SU, you need to do it through the HDI container, not through the SAP HANA Cockpit User Management, as I know.

[sPatil]

Thanks for the answer. Could you guide me more on how to perform User Activation from HDI Container end ?

[HakanHaslaman]

I not deeper familiar with this topic, but i guess this have to be done programmatically via the HDI using an API. You might have to involve someone who's proficient with APIs and SAP HANA development.