SAP Knowledge Base Article - Public

3535770 - When creating a model based off of Hana connection, users can see more queries than they are authorized to in SAP Analytics Cloud (SAC)

Symptom

When a user creates a new model based off of a Hana connection, they are given a list of available Hana cubes to use.  If the authorizations aren't set up correctly, then users may be able to see the list even when they are not supposed to.

Environment

  • SAP Analytics Cloud (Enterprise) 2024.1.1

Cause

This happens when the user has been granted rights on the base catalog object instead of on the actual queries that they are supposed to see.

Resolution

Instead of granting select rights on the base _SYS_BIC object as below

image (5).png

The user should only be granted select rights on the specific queries they should be using.  As in the screenshot below.

image (6).png

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Hana, query, unauthorized, view, rights , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0