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, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


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.

ALTER USER KODYAZ RESET CONNECT ATTEMPTS

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.

SELECT
 USER_NAME,
 USER_ID,
 USER_DEACTIVATED,
 DEACTIVATION_TIME,
 LAST_SUCCESSFUL_CONNECT,
 LAST_INVALID_CONNECT_ATTEMPT
FROM "SYS"."USERS"
WHERE USER_DEACTIVATED = 'TRUE';

SAP HANA database users sys view






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








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