Skip to Content

Scenario:


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.


Solution:


Step1: Create HANA user

Create a HANA user in HANA studio for Example CHARI

/wp-content/uploads/2015/05/image1_696631.png

/wp-content/uploads/2015/05/image2_696680.png

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.


          /wp-content/uploads/2015/05/image3_696681.png

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

              /wp-content/uploads/2015/05/image4_696682.png

    • Include the view objects in it.

/wp-content/uploads/2015/05/image5_696686.png

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

                     /wp-content/uploads/2015/05/image6_696687.png    

    • 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

                            /wp-content/uploads/2015/05/image8_696692.png

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

                               /wp-content/uploads/2015/05/image9_696693.png                         

      • 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

         /wp-content/uploads/2015/05/image12_696694.png

  • Provide user id and pw

             /wp-content/uploads/2015/05/image13_696695.png

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

                  /wp-content/uploads/2015/05/image14_696696.png

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