this will list all users in HANA systems. Prerequisite: We need a database user with DATA ADMIN or CATALOG READ assigned.ġ> Connect to the required system via HANA StudioĢ> Open Administration perspective, You can open it from Window -> Open -> Perspective -> Administration Console
Requirement: We want to list SAP HANA users with their lock status.
We want to list down all users created in SAP HANA system with locked/Unlocked status. How to list all SAP HANA users with their lock status? Indexserver.ini > password policy > maximum_invalid_connect_attempts = 6 To improve your experience, we use cookies to remember log-in details and provide secure log-in, collect statistics to optimize site functionality. Cookies are important to the proper functioning of a site.
A database user may be locked because of the (default) password policy defined: Install the streaming analytics plugin for SAP HANA studio, add a connection to the streaming analytics server, and create a HANA service. Live Example : Our ERP Test schema was getting locked in SAP HANA and it was causing a downtime for the Customer application, we had to enable an audit policy on HANA to find out who’s locking the user. This Topic will explain about how to unlock the schema in SAP HANA and below sql's provide information about how to unlock the user in SAP HANA.