SAP Knowledge Base Article - Preview

3380201 - Users other than HDLADMIN cannot run sp_iqdbspace in Data Lake Relational Engine

Symptom

If you add a user other than HDLADMIN in DataLake and execute sp_iqdbspace, an error will occur.

Could not execute 'sp_iqdbspace'
Error: (dberror) [-204]: You do not have 'SET ANY CUSTOMER PUBLIC OPTION' system privilege or authority to set the option 'auto_commit'


Read more...

Environment

  • SAP HANA Cloud, Data Lake SQL Reference for Data Lake Relational Engine

Product

SAP Datasphere all versions

Keywords

"Data Lake", "IQ", "SAP IQ", sp_iqdbspace, grant, "SET ANY CUSTOMER PUBLIC OPTION" , KBA , HAN-CLS-HC-HDL , HANA Cloud HANA Data Lake , BC-SYB-IQ , Sybase IQ , How To

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.