SAP Knowledge Base Article - Preview

3303324 - Grant access to the TCMP schema for data loads - SAP Commissions & SAP HANA Smart Data Integration

Symptom

  • Try to setup a project so SDI can load into the TCMP staging area, and failed with an error when building a hdbgrants file.
  • Error: "Processing "src/grants.hdbgrants"...Using grantor service "..." of type "sql" Error: Error executing: GRANT "SELECT","INSERT","UPDATE","DELETE","DROP","ALTER" ON SCHEMA "TCMP" TO "...#OO";(nested message: insufficient privilege: Detailed info for this error can be found with guid 'C72DF1C0FE4E0B4EA46311B94EA86C58') grantor service: "...", type: "sql", user: "PS_*" file name: src/grants.hdbgrants(0s 249ms) "


Read more...

Environment

  • SAP Commissions
  • SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , CEC-SAL-COM , SuccessFactors Incentive Management , 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.