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
- 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