maintain-dac-data

Maintain Data for a Data Access Control

In this exercise we will maintain data of a Data Access Control and grant your user access to specific data of the view V_MY_ORDERS. This you will do by editing and inserting new entries directly into the Data Access Control table T_DAC_DATA. Of course, you could also upload CSV file, which contains the access values for all users.

For more information on Data Acccess Control please see the SAP Help site.

Maintain allowed value in T_DAC_DATA

In the first step you define a local table, which contains the allowed value for a user.

1. Navigate to the Repository Explorer

2. Search and open the table T_DAC_DATA
   
   

3. Click on the Open Data Editor button to enter the editing mode of the table:
   
   

4. Click on the Add button to create a new record with the following values:

   ALLOWED_VALUE	USER_EMAIL	USER_ID
   9004	your user email	your user id

   
   
   

5. Click on the Save button to insert the records into the table.
   
   

Data Preview in View V_MY_ORDERS

6. Navigate to the Repository Explorer
7. Search and open the view V_MY_ORDERS
   
   
8. Select on the Output Node the Data Preview from the context menu. As a result you should be able to see only data for Company Code 9004, which is maintained in the table T_DAC_DATA