2787578 - Running a HANA view fails with error "User _SYS_REPO is not allowed to grant privilege SELECT for TABLE" or "User <USER> is not authorized because of missing valid privilege SELECT for VIEW"

• 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: [258]: insufficient privilege: Not authorized: line 1 col 26 (at pos 25)

  or

  SAP DBTech JDBC: [258]: insuficious private: Detailed info for this error can be found with guid '<GUID in "insufficient privilege" error>' 

  and CALL SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('<GUID in "insufficient privilege" error>', ?); returns following information:
  

• And a data preview on the calculation view shows the error "Data Preview is not possible; object is either inactive or broken. If it is an inactive object, activate it, else redeploy.":
  

• 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

  or

  User <USER> is not authorized because of missing valid privilege SELECT for VIEW _SYS_BIC.<package>/<view_name>
  User <USER> tried to execute 'select * from "_SYS_BIC"."<package>/<view_name>"

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP HANA, platform edition 1.0
• SAP HANA, platform edition 2.0

HANA, _SYS_REPO, WITH GRANT OPTION, GRANTABLE TO OTHERS, privilege, authorized, repository, catalog, can be found with guid, NO STRUCTURED PRIVILEGE CHECK, , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem