SAP Knowledge Base Article - Preview

3344029 - Deployment of TRIGGER privilege failing with the error "invalid privilege"

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

  • A hdbrole artifact was created like this:

    {
      "role": {
        "name": "createTrigger",
        "object_privileges": [
          {
            "name": "<tablename>",
            "type": "TABLE",
            "privileges": [
              "TRIGGER"
            ]
          }
        ]
      }
    }

  • Deployment of that artifact is then failing with the following error:

        Deploying "src/createTrigger.hdbrole"... 
         Error: com.sap.hana.di.role: Could not create the role definition in the database [8254541]
           at "src/createTrigger.hdbrole" (0:0)
          Error: com.sap.hana.di.role: "TRIGGER": invalid privilege for the "<tablename>" object of type "TABLE" [8254522]
            at "src/createTrigger.hdbrole" (0:0)
        Error: com.sap.hana.di.role: Deploying "src/createTrigger.hdbrole"... failed [8212145]


Read more...

Environment

SAP HANA Cloud

Product

SAP HANA Cloud all versions

Keywords

KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , 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.