Symptom
A graphical view or SQL view is created based on an object (e.g., DPP_AUDIT_LOG) under the DWC_AUDIT_READER schema.
The first deployment is successful. However, after a few days, when attempting to re-deploy it, the following error shows in the Datasphere Notifications:
Failed to Deploy "<View Name>" in "<Space Name>"
Review the following errors:
"DPP_AUDIT_LOG" - Failed to Deploy "DPP_AUDIT_LOG"
Root Cause: Insufficient database privileges
Missing Privileges:
Missing "SELECT" privilege on
"DWC_AUDIT_READER"."DPP_AUDIT_LOG"
Resolution:
1. Contact your administrator to grant the required privileges
2. Verify your user has necessary permissions for the target
objects
3. Retry deployment after privileges are granted,
Correlation ID: ***
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
SAP Datasphere
Product
Keywords
invalidated view, audit logs, missing select privilege, insufficient privilege, failed to deploy, configuration audit, preview fails , KBA , DS-SM , Space Management , DS-MD-VIW , Views , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview