How to: |
Row-based access security allows you to see only the rows whose value in a specified column meets a configured value(s). For example, if user ds_b wants to display suppliers whose geographical area equals South or West.
In this example, all views regardless of which columns are allowed access for a specific user, a total of 1,110 records in the Supplier Master domain have been reported, as shown in the following image.
Before proceeding with using the Show Data column in the Enhanced Security management tool to configure row-based access security, the Row Criteria Based Authorization Enable setting must be set to true in the Omni Console. To enable this setting from the Omni Console, click Configuration, select Managed Services, click the OGC Tomcat tab, and then change the switch to true. When you have finished enabling this setting, click Services in the left pane, and then click Restart All.
To configure row-based access security:
Note that in this example, there are three other Supplier Master Column sets.
The resulting value is displayed like a filter. For example:
‘<column name> equals: <value1, value2…>'
Note that in an upcoming release, a drop-down list with available values for specific columns will be implemented.
To delete a created or edited Column set, click the Delete button.
To remove individual access security rules:
Note that in the Supplier Master Count display, 1,110 records (rows) are no longer accessible, but rather only 161, which meet the Primary_geo_area=West criteria.
Note also that you can include more than one criteria value in the Show Data column for any displayed column. The criteria values are automatically evaluated using the OR operand to determine the display of each row. For example, the following image shows the second value of South being entered for Primary_geo_area.
The resulting search criteria, West or South displays 318 Supplier Master rows, as shown in the following image.