Symptom
When you run a BW query, the following error message is shown.
insufficient privilege: Not authorized
Error 258 has occurred in the BWA/SAP HANA server
Error reading the data of InfoProvider XXXXXX
Error while reading data; navigation is possible
>> Row: 59 Inc: MAP_TREX_EXCEPTION Prog: CL_RSDRH_TREX_STORAGE
In dev log, you could find information as below:
C SQLCODE : 258C SQLERRTEXT : insufficient privilege: Not authorized
C sc_p=1147cab88,no=201,idc_p=(nil),con=0,act=0,slen=108,smax=256,#vars=3,stmt=116b7bdd0,table=
C CALL SYS.TREXviaDBSLWithParameter( ? , ? , ? , 'ROUTE_BY_TABLES("SAP<sid>"."0BW:BIA:<sid>:XXXXXX\
C D" )' ) ;
Or in HANA indexserver trace, you could find below information:
[00000]{00000}[00/-1] YYYY-MM-DD HH:MM:SS.ss i Authorization SQLFacade.cpp(02528) : User <schema owner user> is missing privilege EXECUTE for PROCEDURE/FUNCTION SYS.TREXVIADBSL
[00000]{00000}[00/-1] YYYY-MM-DD HH:MM:SS.ss i Authorization query_check.cc(03728) : User <schema owner user> tried to execute 'CALL SYS.TREXviaDBSL ( ? , ? , ? )'
Read more...
Environment
The issue occurs in a system with all the following patches and fixes applied.
Product
Keywords
Error 258, Insufficient Privilege, HANA, RSRT, BW report, authorization, TREXVIADBSLWITHPARAMETER, permission, TREXviaDBSL , KBA , HAN-DB-SEC , SAP HANA Security & User Management , BW-BEX-OT , OLAP Technology , BW-BEX-OT-DBIF , Interface to Database , How To
About this page
This 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.