Skip to Content
1
Mar 25, 2020 at 09:56 PM

SAP Hana insufficient privilege

4182 Views

Hello,

I am trying to select (select * from "_SYS_BIC"."sac.calculation_views/cv_provision_transaction_2") a calculation view created in the SAP HANA web-based development workbench but the below error message appears :

PM (SQL Editor) Could not execute 'select * from "_SYS_BIC"."sac.calculation_views/cv_provision_transaction_2" '
Error: (dberror) 258 - SQL error, server error code: 258. insufficient privilege: search table error: insufficient privilege: Not authorized: line 1 col 60 (at pos 60)

The calculation view is created from a view from this view :


CREATE VIEW THEMIS.sac_provision_transaction
AS
SELECT "ID",
"SiteID" AS "Site",
"Quantity",
"ProductID"
FROM themis."ProvisionTransaction";

The user used has the below roles and priviledges

I executed this :

GRANT SELECT ON SCHEMA "THEMIS" TO _SYS_REPO WITH GRANT OPTION

Thank you for your help.

Sincerely,

Axel

Attachments

ivvrr.png (54.7 kB)
7qtj4.png (57.4 kB)