Symptom
When you try to generate planviz for a 'call trexviadbsl' query, below error shows:
SAP DBTech JDBC: [258]: insufficient privilege: Not authorized.
The query usually has below format:
Call trexviadbsl ('olapSearch' , to_blob(hextobin ('xxxLong HEX codexxx'), ?);
And you found below error in the indexserver trace:
i TraceContext TraceContext.cpp(01114) : UserName=<user name>, ApplicationUserName=<user name>, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$1.run(SQLExecuteFormEditor.java:920);,......
e Row_Engine qe_proc_call.cc(00559) : insufficient privilege [ptime/query/checker/query_check.cc:4799]
Read more...
Environment
-
HANA Platform 1.0
-
HANA Platform 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
insufficient privilege; Not authorized; call trexviadbsl; call TrexViaDbslWithParameter; planviz; HANA Studio; Visualize Plan; , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , HAN-DB-SEC , SAP HANA Security & User Management , Problem
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.