cancel
Showing results for 
Search instead for 
Did you mean: 

What privilege is required to view the data in Webi report

Former Member
0 Kudos

Hi,

I have created an information model in HANA and designed an Universe in IDT. When I run a webi report on the Universe I am getting the follwoing error.

What privilege I should have to view the data on the report.

FYI, My HANA and Webi User ids are not same.

SAP DBTech JDBC: [2048]: column store error: search table error:  [2950] user is not authorized. (IES 10901) (WIS 10901)

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

rama_shankar3
Active Contributor
0 Kudos

If your user ID's are different, please hard-code the HANA user ID in the IDT connection and make sure that the HANA ID has all the grants - hope this helps !  - Rama

former_member184768
Active Contributor
0 Kudos

Hi Bharath,

Can you please check which user id is used for WebI or IDT to connect to HANA user. As Henrique mentioned, ensure that SELECT privilege are assigned to that user on the target schema or HANA objects.

Regards,

Ravi

henrique_pinto
Active Contributor
0 Kudos

User should have SQL privilege (at least SELECT) on the target Schema containing the underlying tables.