Symptom
The following errors are encountered when a HANA stored procedure is called with an application user, which requires the creation of a temporary table:
- SQLFacade.cpp(02528) : User <USER_NAME> is missing privilege CREATE TEMPORARY TABLE for SCHEMA <SCHEMA_NAME>
- i Authorization query_check.cc(03710) : User <USER_NAME> tried to execute 'CREATE LOCAL TEMPORARY TABLE "...'
- e SQLScript trex_llvm.cc(00901) : Llang Runtime Error: Exception::SQLException258: insufficient privilege: Not authorized
Read more...
Environment
SAP HANA 1.0
Product
SAP HANA 1.0, platform edition
Keywords
CREATE LOCAL TEMPORARY TABLE INVOKER DEFINER , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-STD-DEV-MOD-CLT , SAP HANA Analytical Modeling Client , 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.