- You run a calculation view in the SQL editor and get the following error:
Could not execute 'select * from "_SYS_BIC"."<package>/<view_name>"'
SAP DBTech JDBC: : insufficient privilege: Not authorized: line 1 col 26 (at pos 25)
- And a data preview on the calculation view shows this error:
- You collect an authorization trace as per SAP Note 1809199 and the indexserver trace file prints entries like these:
User _SYS_REPO is not allowed to grant privilege SELECT for TABLE <schema>.<table_name>
User <USER> is not authorized to use VIEW _SYS_BIC.<package>/<view_name> because of missing grantable privileges on underlying objects
- SAP HANA 1.0
- SAP HANA 2.0
HANA, _SYS_REPO, WITH GRANT OPTION, GRANTABLE TO OTHERS, privilege, authorized, repository, catalog , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.