Insufficient authorization - Not authorized Error

[Former Member]

Hi Experts,

We are using a BW on HANA system and I have created a calculation view on top of one of the active table(generated from BW DSO) in hana studio. We wanted to create the end user role so that they can access this calculation view. We have created a role and assigned them the below privileges:

Object Privileges -

Calc_View(_SYS_BIC) - select

Repository_Rest(_SYS) - Execute

SAPBWH(schema containing my active tables) - select

My_Package(where my view resides)

Also, we have granted the select privilege with grant option to the SYS_REPO. Still I am not able to view the data preview of the calculation using the user having assigned the above role. Surprisingly, If I try to execute the select statement for the said view in SQL console, I am able to see the data using the user having above role assigned. I have searched a lot on scn but was not able to resolve this error "Insufficient authorization - Not authorized Error".

Appreciate your thoughts on this. Thanks in advance!!

Regards,

Vishal

[lucas_oliveira]

Hi,

You're probably missing the analytic privilege for reading the data. Most of the boiler plate code for object creation / assignment can be done by BW directly through transaction RS2HANA_ADMIN. Maybe try using that instead of manual assignment (or keep that at a bare minimum).

Regards,

Lucas de Oliveira