User Management

The framework does not require special users in AS ABAP. Standard mechanisms should be followed with the SAP NetWeaver Application Server, such as tools, user types, and password policies. On the other hand, a reference user needs to be created for SAP HANA.

To create a reference user, proceed as follows:

1. Create framework reference user in SAP HANA.

   At least one reference user is needed in SAP HANA to access the framework’s spatial data on behalf of all end users. You can create your own reference user or reuse an existing one. In either case, write down the user name, say SAP_GEF_USER. Also, avoid using a password policy like periodical password change on this user, because this may disable the user account and the corresponding DB connection in the future. For more information, see

   Create and Authorize a User

2. Authorize the reference user you just created.

   Run the following stored procedure to assign the required authorization:

   call "_SYS_REPO"."GRANT_ACTIVATED_ROLE" ('sap.gef.data::gef_user', 'SAP_GEF_USER1')

   To revoke the authorization, use procedure REVOKE_ACTIVATED_ROLE.

   You can also use the SAP HANA Studio to assign object privileges (to access schema SAP_GEF) to the reference user directly, such as SELECT, INSERT, UPDATE, and DELETE.

3. If the reference user is also used to access other business data, grant other authorizations accordingly.

For more information, see Prerequisites for Granting and Revoking Privileges and Roles.