Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To apply OR condition between dimensions in Dynamics Row Level Security, follow these steps:

  1. Open the Security Role in which you want to apply the OR condition.

  2. Navigate to the Security Tab and click on the Row-Level Security option.

  3. Click on the Edit button to edit the existing Security Policy.

  4. In the Security Policy window, click on the Add Group button to add a new group.

  5. In the Group Name field, provide a suitable name for the new group.

  6. In the Rows section, click on the Add button to add a new row.

  7. In the Row section, select the dimension for which you want to apply the OR condition.

  8. By default, the AND condition would be selected. To change it to OR, click on the dropdown menu and select the OR option.

  9. Add the value or range of values for the selected dimension.

  10. Repeat the same steps for other dimensions in the OR condition.

  11. Save the changes and close the editor.

Now, the OR condition has been applied between dimensions in Dynamics Row Level Security. The user will have access to the data if it matches any of the dimensions with OR condition applied.