Hey! That's My Data! – Authorizations in SAP HANA | Software Development on the SAP HANA Platform

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, analytic or calculation views)	In the Quick Launch panel under the Analytic Privileges tab and Create. Give name, description, select concerned models, select desired attribute name(s), appropriate value(s) for restriction, and activate. Remember...

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, analytic or calculation views)

In the Quick Launch panel under the Analytic Privileges tab and Create.

Give name, description, select concerned models, select desired attribute name(s), appropriate value(s) for restriction, and activate.

Remember...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Software Development on the SAP HANA Platform

By : Mark Walker

Software Development on the SAP HANA Platform

By: Mark Walker

Overview of this book

Quick reference

Software Development on the SAP HANA Platform

By : Mark Walker

Software Development on the SAP HANA Platform

By: Mark Walker

Overview of this book

Quick reference

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access