Show TOC

Generating and Assigning Roles for Technical UsersLocate this document in the navigation structure

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

Note

You must always perform this procedure after you have created a new connector whose external files are to be indexed using the file loader.

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 required role.
  2. Switch to SAP HANA studio and execute the SQL commands generated by the ABAP system in the SQL console. A new role is created.
  3. In SAP HANA studio, assign the new role to the technical database user of the file loader.