SAP Knowledge Base Article - Preview

3543492 - How-To: Troubleshoot Authentication Errors Using View AUTHENTICATION_ERROR_DETAILS From HANA 2.0 SPS08

Symptom

Starting from HANA 2.0 SPS08, authentication errors occurring during connection using a client or SQL statement are recorded in system view SYS.AUTHENTICATION_ERROR_DETAILS. You can use it to track the authentication failures and check how user is locked due to invalid logon attempts.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

SAP HANA Platform Edition 2.0 SPS08 and above

Product

SAP HANA, platform edition 2.0

Keywords

AUTHENTICATION_ERROR_DETAILS, analyze locked user, user lock, authentication error, authentication failure, Failed Authentications , KBA , HAN-DB-SEC , SAP HANA Security & User Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.