Smart Data Integration: [140028] Insufficient privilege. Access denied
source link: https://blogs.sap.com/2015/08/07/smart-data-integration-140028-insufficient-privilege-access-denied/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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.
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.
Thanks must go to my colleague and SAP HANA guru Guneet Wadhwa for exploring the intricacies of SDI and Authoizations with me.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK