SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Install SAP Free

Activate SAP HANA Database User on Web-based Development Workbench

Because of too many invalid connect attempts, I had to activate SAP HANA database user on Web-based Development Workbench using SYSTEM user.
Since I could not remember correctly the HANA database user password, I had to reset the database user password for authentication. But since I had tried to connect with false passwords for the HDB user for a numerous times, I realized that the user status was "Deactivated". In addition to define a new password for the SAP HANA database user, I had to activate user again on the SAP HANA Web-based Development Workbench tool.

As you can see in below screenshot from Web-based Development Workbench IDE, the HANA database user is in Deactivated status because of the reason "Too many invalid connect attemps"

SAP HANA database user deactivated

To activate the database user on the HANA database, press the Activate icon on the application toolbar.

activate HANA database user

If the activation is successfull, you will see following message on the Security Editor: Activating user "KODYAZ" succeeded

It is also possible to activate a user using SQLScript commands like "ALTER USER" command as follows.
Please note that I executed following SQL statement with SYSTEM user.


SAP HANA database users can query the SYS.USERS view for the status of the HANA DB users and check for deactivated users with following SQL query.


SAP HANA database users sys view

SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table

Meetup Sunumu 1 meetup

Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems