How to get Insufficient Privilege Details for GUID
Aus MattWiki
In case of errors due to insufficient privilege and a GUID like here:
SELECT * FROM "200"."Warenkorbanalyse_TF$TF"('000000000000335511', ...'
Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid '1234567890123456789042
Or 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
- Open SAP HANA Database Cockpit
- Switch to Securiy and User Management Console
- Look for Panel "Insufficient Privilege Details" and enter GUID into input field
2. Use Database Procedure
- Open SAP HANA Database Explorer
- Search for Procedure GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS
- 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 => ?)
For more details see: https://help.sap.com/docs/SAP_HANA_COCKPIT/afa922439b204e9caf22c78b6b69e4f2/9a33043bc2c14981a92bf0f09c794789.html