Quick reference

Here is a quick overview of the main concepts we've seen concerning authorizations in SAP HANA:

Object

Usage

Creation

Role

Group authorization objects together

In the Navigator panel select Security folder and expand it, then select the Roles folder and New Role.

Give a name, add other authorization objects, and Deploy.

SQL privileges

Grant access to base SQL objects in the database (tables and schemas for example)

In role definition go to the SQL Privileges tab click on Add select object by name, select desired SQL rights (SELECT, INSERT, and so on).

Remember to give SELECT to _SYS_BI and _SYS_REPO, and execute to REPOSITORY_REST.

Analytic privilege

Grant access to specific values returned by analytic models (attribute, ...

Get Software Development on the SAP HANA Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.