Apply a Data Access Control to a Graphical or SQL View

You can apply one or more data access controls to a view to control the data that users will see based on the specified criteria.

Context

For detailed information about defining and using data access controls, see Securing Data with Data Access Controls.

Procedure

  1. In the left navigation area, click Data Builder and select the space you want to work in.
  2. Open the object that you want to apply the data access control to.
  3. Select the output node of the view and open the Data Access Control list in its side panel.
    The list contains data access controls applied directly to the object, and those:
    • Applied via Dimensions - When a modeler creates an association from a fact to a dimension, they can select the Apply Dimension Data Access Controls to Fact option, and it will appear in this sub-list.

    • Applied via Sources - When a data access control is applied to a source in the object's lineage it will appear in this sub-list.

  4. Click (Add) to open the Select Data Access Control dialog, choose the data access control to apply, and click Select.
  5. In the Join section, map columns from your object to the columns defined in the data access control.

    You must map a column from your object to each of the criteria columns defined in the data access control in order to correctly filter the data by the criteria.

  6. Click (Deploy) to save and deploy the object.
    Users opening your object in SAP Datasphere or in SAP Analytics Cloud or other analytics tools will only see the data permitted by their permissions as defined in the data access control.