Skip to Content
0

HANA User History Table Information

Aug 02, 2017 at 10:20 AM

120

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Michael Healy
Aug 02, 2017 at 12:32 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Michael,

Yes .I tried from SYS_USERS table where I can see last connectivity of user, But I would like to achieve for particular user how many times he logged in.

I Just gone through below thread, so I posted whether we can get from audit logs setting an alert.

https://archive.sap.com/discussions/thread/3907890.

Thanks,

Neeluri

0