3479368 - How to parse the GUID string in insufficient privilege error message in SAP Dataphere

When creating a SQL view in SAP Dataphere, the Validation Messages shows below error:

insufficient privilege: Detailed info for this error can be found with guid 'xxx', Code: 258, SOL State: HY000

This KBA describes the steps about how to figure out which user missing what privileges. 

"Images/data in this KBA are from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Datasphere

1. Create a SQL view in SAP Dataphere.
2. Click "Validate SQL" button to show the error message.

1. Create a Database Analysis User - SAP Help Portal Documentation: Create a Database Analysis User to Debug Database Issues
   
2. There are two ways to check the details.
   1. Use SAP HANA Cockpit.
      1. Click "Open SAP HANA Cockpit" and logon.
         
         
         
         
      2. Select "Security and User Management".
         
          
         
         
      3. In "Insufficient Privilege Details" tile, input the GUID string, press Enter button to show the details, and even click "Assign Privileges" to grant missing permission to the user.
         
         
         
         
   2. Use Database Explorer.
      1. Click "Open Database Explorer" and logon.
         
         
         
         
      2. Open SQL console by clicking the icon.
         
         
         
         
      3. Run below SQL(replace <GUID> with the one in the error message):
         CALL GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS('<GUID>', ?);
         The result likes below. TESTUSER is missing SELECT object privilege on table CUSTOMERS of schema SYSTEM, just grant what's missing.
         
         

KBA 3271174 - How to parse the GUID string in insufficient privilege error message of HANA database?

missing authorization, logon hana DB, , KBA , DS-MD-VIW , Views , DS-DI , Data Integration/Data Builder , DS-SEC , Security (Users, Roles) , How To