When connecting to HANA online option from Lumria  the package level security applied in HANA is not getting reflected, It display all the packages in HANA system.


Step1: Create HANA user

Create a HANA user in HANA studio for Example CHARI



Step2: Assign specific privileges to the HANA user

In the system privileges tab:

  • Verify if _SYS_B_CP_ALL Analytic Privilege is assigned at CHARI user role; if assigned already, then remove it, as by default it will show all the views from HANA.


    • Create a specific Analytical privilege on “Lumira” package in HANA by selecting the Lumira package -> right click ->new Analytical privilege.


    • Include the view objects in it.


    • Assign the Analytic privilege object (the one you have created) in the user’s Analytic Privilege tab.


    • Assign the following object privileges to the user.
      • Grant “Select” privilege in the right tab for _SYS_BI & _SYS_BIC  schema.                       /wp-content/uploads/2015/05/image7_696688.png


      • Grant “Execute” privilege for the procedure object “REPOSITARY_REST”.


      • Select the specific package privilege for the user
      • Click on save and activate

Step3: Test the user from SAP Lumira

  • Now log in to HANA from Lumira.From “File” menu create a new dataset by clicking on “New” .
  • Select “Connect to SAP HANA” option


  • Provide user id and pw


  • You will see only the objects you are authorized to view from HANA


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply