Symptom
Consuming a view with data access control (DAC) on a data flow causes an error, such as "Cannot add view 'xxxx'. A data access control has been applied to this view or a dependent view."
Environment
SAP Datasphere
Reproducing the Issue
- Access the Data Integration Monitor
- Select the required space
- Select tab Flow and then tab Dataflow
- Check the validation messages
Cause
Using a view with DAC on a data flow disables data protection. This results in a non-ideal data flow process that doesn't function correctly with protected data, and the semantics will be incorrect. Consumption from this view will resemble a snapshot.
Resolution
You cannot use a DAC to transform or transport data via Dataflow. Review the semantic usage for this view and the data flow.
See Also
- SAP Help - Persisted Views and Data Access Control
- SAP Help - Creating a Data Flow
- SAP Help - Securing Data with Data Access Controls
Keywords
Dataflows, error message, DS, DT , KBA , DS-DI-DF , Data Flows , Problem
SAP Knowledge Base Article - Public