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
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.