Show TOC

Creating Analytic PrivilegesLocate this document in the navigation structure

Use

You grant access to objects in SAP HANA, in this case analytic views, by assigning the required roles to users. However, to see any of the actual data contained in these views, you must also assign the appropriate analytic privileges to the users. Based on the requirements of your organization, you can define analytic privileges that grant access to only specific entries or rows in a view, or you can define analytic privileges that grant access to all data contained in a view. Without the correct analytic privileges, a user only sees an empty view.

Procedure
  1. Identify the current restrictions your organization has placed on entries in the SAP HANA Live views.

  2. Based on these restrictions, create analytic privileges using SAP HANA Live Authorization Assistant.

  3. Grant the analytic privileges to the appropriate users.

Recommendation

If your organization has set up existing authorizations in the ABAP system that you want to similarly apply to the views in SAP HANA, we recommend using the Eclipse plug-in SAP HANA Live Authorization Assistant for SAP HANA studio. It supports the generation of analytic privileges for query views by transforming users’ ABAP authorizations to appropriate SAP HANA analytic privileges.

More Information

For information about creating and granting analytic privileges in SAP HANA, see http://help.sap.com/hana_platformStart of the navigation path Development and Modeling Next navigation step SAP HANA Modeling Guide for SAP HANA Studio Next navigation step Defining Data Access Privileges Next navigation step Create SQL Analytic Privileges End of the navigation path.

For more information about defining privileges using SAP HANA Live Authorization Assistant, see http://help.sap.com/hbaStart of the navigation path Installation, Security, Configuration, and Operations Information Next navigation step Administrator’s Guide Next navigation step Security Next navigation step Authorizations Next navigation step Privileges End of the navigation path.

For more general information about analytic privileges in SAP HANA, see http://help.sap.com/hana_platformStart of the navigation path Security Next navigation step SAP HANA Security Guide Next navigation step SAP HANA Authorization Next navigation step Analytic Privileges End of the navigation path.