How to check HANA user's last login time and invalid connect attempts made

You want to know when an user last logged in to HANA system , or want to check any unsuccessful connection attempts made with particular user, especially in case of communication user.

We will make use of system view INVALID_CONNECT_ATTEMPTS to get required information.

Requirement : You want to know last login date and invalid connect attempts of HANA user.

Prerequisite : You need CATALOG READ or DATA admin role  or SELECT access on SYS schema.

Steps :
Connect to HANA system and open SQL console in HANA studio or via hdbsql at OS level.
Execute following SQL

 SELECT * FROM "SYS"."INVALID_CONNECT_ATTEMPTS" WHERE USER_NAME  ="anyUserName";