Generating and Assigning Roles for Technical Users

The file loader requires authorizations to be able to access the database tables of connectors in Embedded Search.

Context

These tables are accessed using a technical database user. This user needs access rights, which you have to assign with the help of a role in SAP HANA.

More information about technical database users: File Loader Guide for SAP HANA

Procedure

To create and assign this role, proceed as follows:

  1. In the ABAP system, call transaction SE38 and execute the report ESH_FL_CREATE_SQL_4_HANA_ROLE. This report opens a text field with SQL commands that you need for the next step. The SQL commands generate the new required role IFL_TABLE_ACCESS_ROLE.
  2. Switch to SAP HANA studio and execute the SQL commands generated by the ABAP system in the SQL console. The new role is created.
  3. In SAP HANA studio, assign the new role to the technical database user of the file loader.