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
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

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
Code

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';
Code

SAP HANA database users sys view



SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.