Skip to Content
avatar image
Former Member

HANA User History Table Information

Hi,

Can we get how many times user had logged into Hana system( history information) .

I am able to fetch user last active information but I want to achieve how many times particular user has logged in.

Is it possible to achieve enabling audit status in HANA?

Thanks in Advance.

Regards,

Neeluri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 02, 2017 at 12:32 PM

    Hello,

    I wouldn't imagine this can be done. Querying from "SYS"."USERS" can give you some details but as audit logs are a split into three levels

    1: ALERT

    2:CRITICAL

    3:EMERGENCY

    What level would you think to put this in? I would hardly think a user logging into a system would fit any of these levels. I am not saying its not possible because I am not sure but it would make no sense to me in terms of auditing.

    Add comment
    10|10000 characters needed characters exceeded