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";
View's column description.
Column name
|
Description
|
USER_NAME
|
Name of
the user
|
SUCCESSFUL_CONNECT_TIME
|
Time of
the valid connect attempt
|
INVALID_CONNECT_ATTEMPTS
|
Number
of invalid connect attempts for this user between last successful connect and
given time
|
Tags : How to check
last login date and time of particular user?