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 => ?)