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.

help.sap.com/download/multimedia/hana_options_eim/SAP_HANA_EIM_Administration_Guide_en.pdf

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.

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.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply