SAP Knowledge Base Article - Preview

3136268 - RSDANLCON - IQ NLS for SDA returns "Permission denied..." - SAP IQ

Symptom

1. Configure the smart data access (SDA) environment

2. Error happens when set the configuration of the Near-Line Storage (tx. RSDANLCON)

Permission denied: you do not have permission to use the "CTEATE Table" statement.
Exception occurred in line 56 of include CL_SQL_STATEMENT==============CM002

3. Try to create a table with user SAPIQUSER in IQ DB also meet error: 
Could not execute statement. Permission denied: you do not have permission to create objects in dbspace "USER0001" SQLCODE=-121, ODBC 3 State="42000"


Read more...

Environment

  • SAP IQ 16
  • SAP Business Warehouse on HANA
  • SAP HANA Smart Data access

Product

SAP BW/4HANA 2.0 ; SAP IQ 16.0 ; SAP IQ 16.1

Keywords

RSDANLCON , SDA(Smart Data access), Permission, IQ, NLS, BW, Create table, CL_SQL_STATEMENT, CM002  , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , BC-SYB-IQ , Sybase IQ , 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.