Skip to Content

Insufficient authorization - Not authorized Error

Nov 14, 2016 at 12:31 PM


avatar image

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!!



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lucas Oliveira
Nov 15, 2016 at 02:43 AM


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).


Lucas de Oliveira

10 |10000 characters needed characters left characters exceeded