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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.