SAP Knowledge Base Article - Preview

3271031 - Performing DDL on an HDI Table Fails

Symptom

One or more of the following statements apply to your scenario:

  • You want to modify the definition of an HDI managed table.

  • Due to the size of the table data associated with the HDI table, you do not want to incur the downtime and/or deployment time associated with modifying and redeploying the design-time .hdbtable file.
  • Attempting to perform an unsupported DDL statement such as:
    ALTER TABLE <schema_name>.<table_name> DROP PRIMARY KEY;
    results in an "insufficient privilege" error and associated GUID.

  • Running the SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS procedure, you identify the a missing schema privilege but cannot grant the privilege using an .hdbrole, etc. because you receive a message like "invalid schema privilege."


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

partition, partitioning, enable_container_schema_privileges_index_trigger_references, TRIGGER, INDEX, hdbtable, hdbdropcreatetable, hdbmigrationtable, migration, redeploy, redeployment, deploy, deployment, HDI, HANA Deployment Infrastructure , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , 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.