Datasphere - Last Logon Time

[klorn_pallier]

Hi,

Is there a table I can use in the Sys Schema to get a Datasphere's user last logon time?

[XaviPolo]

I think that In HANA standar tables you will find only HANA DB Users (like created for Open SQL), but not the  DSP Users (they don't access HANA with their own HANA DB user)

As far as I know, the DSP task control views and the space audit are the only published data of DSP but nothing that is user-only.

Maybe in the audit the login appears (but I think not), although activating the audit of a space only for this is perhaps too much.

Regards,

[Martin_Kuma]

Yes, you would need to create a DB user for each user. For now there is no statistics like in BW.

[Savio_Dmello]

you can query the SYS.USER table, which contains details about user logon events, including the last logon time. Sorry for typo

Thanks

Savio

[klorn_pallier]

Thanks Savio. I can see a SYS.USERS table but not this one. Do you need to be System Owner to view this?

[Martin_Kuma]

There is only the SYS.USERS... At least this is what I know. seems the SAP reference: https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/21026099751910148e0cdbd... confirms