Securing logging in to SAP HANA – privileges
We need certain authorizations to work on SAP HANA models. In order to get the required authorizations, there are privileges. This recipe covers the available privileges.
Getting ready
When we access the SAP HANA database, privileges to data have to be maintained. Privileges can be maintained at different levels.
How to do it…
There are four types of privileges in order to authorize the data in the system: SQL privilege, system privilege, package privilege, and analytic privilege.
Follow the given steps to authorize the data in the system:
Open the user that the privileges on objects are to be given to.
Go to the corresponding user in the user maintenance screen and add the required privilege.
As an example, we will assign all privileges on the SAP_HANA_EPM_DEMO schema to our COOKBOOK_USER, as shown in the following screenshot:
Similarly, we can assign different privileges to the user, thereby providing access to the data.
How it works…
SQL privileges are...
