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

Deploying a view in SAP Datasphere fails with the error message:

Failed to execute a statement due to insufficient privilege

See SAP Note 3456011 - Deploy a view ends with "Failed to execute a statement due to insufficient privilege" message

For how to get more details about the insufficient privilege GUID see:

How to get Insufficient Privilege Details for GUID