my-orders-dac

Use Data Access Control in My Orders View

1. Navigate to the Repository Explorer

2. Search and open the view V_MY_ORDERS, which you have created previously.
   
   
   
   

3. Navigate to the Data Access Control section of the Output Node and add a new Data Access Control.
   
   

4. Select the Data Access Control D_COMPANYCODE.
   
   

5. Map the V_MY_ORDERS.COMPANYCODE column to the Data Access Control D_COMPANYCODE.ALLOWED_VALUE column.

   🎓Note: With the mapping, the data access of the view V_MY_ORDERS is now secured by filtering the data on Company Code with user's allowed values. If user does not have valid entries in the T_DAC_DATA table, he will not be able to see any value.

   
   
   

6. Click on the Deploy button to deploy the view.
   
   

7. Select on the Output Node the Data Preview from the context menu. As a result you should not see any data, since your user does not have any valid access maintained in the table T_DAC_DATA. This will be part of the next exercise :)