Show TOC

Synchronizing SAP HANA Database UsersLocate this document in the navigation structure


Each user requires both a user in the ABAP front-end server to enable navigation in the SAP Fiori launchpad and a database user in SAP HANA to enable access to the relevant views.

SAP supports the following methods for synchronizing SAP HANA database users with the existing users in the ABAP system:

  • User synchronization using SAP NetWeaver Identity Management or an existing Identity Management (IDM) solution implemented in your organization

  • Mass user synchronization using ABAP DBMS user management tools

  • Manual user creation in SAP HANA


When synchronizing users, you do not need to create passwords for SAP HANA database users if you use single sign-on.

  • You have created the required users in the ABAP front-end server.

  • You have enabled single sign-on.

  • For manual user creation, you have the SAP HANA system privilege USER ADMIN.

Mass Synchronization

To synchronize all relevant users automatically for a single ABAP system, use the mass synchronization report provided in SAP Note 1927767 Information published on SAP site.

Using this report, proceed as follows:

  1. Select the relevant ABAP users based on user type, user group, and ABAP authorization role.

  2. Select the SAP HANA roles to be assigned to the relevant users.

By default, SAP HANA database users are created with the same name as the ABAP users.

Manual User Creation

Alternatively, to manually create users in SAP HANA:

  1. In SAP HANA studio, go to the SAP HANA Systems view, choose Start of the navigation path Security Next navigation step Users End of the navigation path.

  2. Create the required database users and ensure that the user names are identical to the corresponding users in the ABAP system.

More Information

For more information about enabling single sign-on, see Setting Up SSO for SAP Fiori Landscapes with SAP HANA XS.

For information about using ABAP DBMS user management tools, see of the navigation path Application Help Next navigation step Function-Oriented View Next navigation step Security Next navigation step Identity Management Next navigation step User and Role Administration of Application Server ABAP Next navigation step Administration of Users and Roles Next navigation step User Administration with DBMS User Management End of the navigation path.

For more information about creating users in SAP HANA, see SAP Help Portal at of the navigation path System Administration Next navigation step SAP HANA Administration Guide Next navigation step Security Administration Next navigation step Managing SAP HANA Users Next navigation step Provisioning Users Next navigation step Provisioning Users in SAP HANA Studio Next navigation step Create and Authorize a User End of the navigation path.