How to get Insufficient Privilege Details for GUID

Aus MattWiki

In case of errors due to insufficient privilege and a GUID like here:

Deploy view ends with "Failed to execute a statement due to insufficient privilege"

Here is how to find more details:

1. Use SAP HANA Cockpit

  1. Open SAP HANA Database Cockpit
  2. Switch to Securiy and User Management Console
  3. Look for Panel "Insufficient Privilege Details" and enter GUID into input field

2. Use Database Procedure

  1. Open SAP HANA Database Explorer
  2. Search for Procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS
  3. Click on Generate CALL Statement which should prepare a new SQL window with content like this:
CALL "SYS"."GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS"(GUID => ''/*<NVARCHAR(256)>*/,RESULT => ?)