cancel
Showing results for 
Search instead for 
Did you mean: 

Error when getting results: insufficient privilege:Not Authorized

aalexis
Participant
0 Kudos

Hello All,

I have built a calculation view and wanted to build a composite provider (BW4Hana)using this calculation view. When I try to create a composite provider (BW4Hana), (Join Providers->Add on the search box when I type the view, the system tries to search but comes back with 'Error when getting results: insufficient privilege:Not Authorized' . There seem to be some authorization missing but not sure what it would be. I am able to create data flow, data source and other BW Objects, but trying to read from Hana native I get this error.

Any idea what Authorization should I have?

Accepted Solutions (1)

Accepted Solutions (1)

aalexis
Participant
0 Kudos

Fredric,

I have all available authentication but still I am getting the same error, obviously something is still missing...

Thanks,

Arthur.

hanlok22
Participant
0 Kudos

Hi Arthur, did you ever resolve this issue? I am running into the same error and wondering how to resolve.

Answers (1)

Answers (1)

FCI
Active Contributor
0 Kudos

Hi Arthur,

The DB user of your BW has probably no read access to your calculation view.

Check its privileges on the hana side.

Regards,

Frederic

aalexis
Participant
0 Kudos

Fredric,

I saw in the BW side (SU01) and the DBUSER has been added/created. What specific read access and where should I need to check. Also the same userid is being used across all systems. if you give me the steps to go thru this problem resolution will be helpful.

Thanks,

Arthur.

aalexis
Participant
0 Kudos

Also read another reply exactly having my issues, and the reply as follows

Please add following Object Privileges to the SAP<SID> data base user profile:
Catalog Object: _SYS_REPO
Privilege: SELECT
Grantable to Others: No
Catalog Object: ACTIVE_OBJECT(_SYS_REPO)
Privilege: SELECT
Grantable to Others: No

But when I looked at the HANA User Profile the above access is assigned at the Object Privileges, but where this can be assigned to as said above ? Please add following Object Privileges to the SAP<SID> data base user profile:

Any idea? explanations?

Thanks,

Arthur.

aalexis
Participant
0 Kudos

Fredric,

I looked at all the privileges and pretty much all are applied that are available within Hana Side. Is there a specific authorization that is responsible for this? I still get this error..

Thank you,

Arthur.

FCI
Active Contributor
0 Kudos

And you're looking at the DB user (not your own) ?

The DB user should have access to the _SYS_BI schema and to the calculation views:

Access to the procedure repository_rest should not be needed in your case.

Regards,

Frederic