How to activate a User from User Management of SAP BTP HANA Cloud Cockpit

[sPatil]

Hi,

In my SAP BTP HANA Cloud Cockpit --> User & Role management, currently one user is in 'deactivated' state and because of it we are not able to perform CRUD operations on SAP HANA Cloud Tables. Kindly guide me how to activate this user.

Thanks.

[Dan_vL · Accepted solution]

In the SAP HANA cockpit, there should be an activate button in the header as shown in the image here once you have opened the details page for a user.
Activate a deactivated user

You can also execute SQL statements to activate and deactivate users as documented at
ALTER USER Statement. 

Regards,

Dan van Leeuwen

[sPatil · Accepted solution]

Hi Dan_vL,

When any new user is created by DBADMIN, then for that new user I am able to see that 'Activate/Deactivate' option as you showed. But the user (for which I asked the question) is created by '_SYS_DI_SU' and I have logged in as DBADMIN hence 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'.

Thanks in advance