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

sap.hana.xs.ide.roles::EditorDeveloper

_SYS_REPO permissions / roles

For the Schema where the Objects are generated, _SYS_REPO requires

CREATE ANY

SELECT

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.

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

1 Comment

You must be Logged on to comment or reply to a post.

Fernando Satorra

June 7, 2018 at 8:26 pm

Nice post, it helped me!

Thank you.