Why does the Database User from a SPACE in SAP Datasphere got locked?

[rebeca_elvetia]

Hello SAP Community Experts

I know why I used gets Locked. Usually, it is because the password expired or the wrong password was used to establish the connection.

We are currently using database users for each productive space so we can consume views created in SAP Datasphere on third party applications like Excel or Power BI through an ODBC connection.

My question is if there are logs where I can check which user (person consuming information) or in which application the database user got locked? Or what happened for the user to get locked?

I check audit logs but every result was successful, I couldn't identify when the database user got locked nor why.

I can access SAP HANA Cockpit, but there I don't know where to look for that information, if there is any info on that.

Do you happen to know where can I check?

Thank you

Rebeca

[Vitaliy-R · Accepted solution]

In SAP HANA database there is a view SYS.AUTHENTICATION_ERROR_DETAILS: https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-security-guide/troubl...

But I am not sure if it is accessible from SAP Datasphere.

[Martin_Kuma]

If it happens every 30 days, then it is because the secret is valid only 30 days.

You should see it in the log file of the consuming service. 

[Rudrapuneet]

Check this out once - https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/c05b6a6d06db427dbdd3041d61...