2482729 - User <USER_NAME> is missing privilege CREATE TEMPORARY TABLE for SCHEMA <SCHEMA_NAME> | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2482729 - User <USER_NAME> is missing privilege CREATE TEMPORARY TABLE for SCHEMA <SCHEMA_NAME>

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 Component , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.