Skip to Content
Personal Insights
Author's profile photo Ian Henry

Smart Data Integration: [140028] Insufficient privilege. Access denied

Have you received the dreaded Authorization error with Smart Data Integration?

[71002048] column store error: task framework:  [140028] Insufficient privilege. Access denied.  .hdbflowgraph   SAP HANA Activation Problem

It is documented, but who reads the manual?

In case you need the link it is here – Page 25 in the SPS10 guide.

It’s quite a frustrating error as there’s no indication as to what permissions are missing from where.

To use Smart Data Integration in SAP HANA SPS09 the following are required

USER permissions / roles


_SYS_REPO permissions / roles

For the Schema where the Objects are generated, _SYS_REPO requires



I was also using a procedure which then requires additional permissions for the schema that holds the Procedure and the Procedure Table Type.

If your procedure is problematic you can all choose

Show Authoizations and you should get an indication of other areas to investigate.

Screen Shot 2015-08-07 at 22.38.23.png

Screen Shot 2015-08-07 at 22.39.31.png

Thanks must go to my colleague and SAP HANA guru Guneet Wadhwa for exploring the intricacies of SDI and Authoizations with me.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Fernando Satorra
      Fernando Satorra

      Nice post, it helped me!


      Thank you.