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 for Me (Login required).

Search for additional results

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