Comment on page
This section explains each of the properties in the configuration blade.
Fig 1: SQL Server Connector configuration blade
Access Control ensures that App users view data they are authorized to see.
The App user is the input parameter to a stored procedure, which returns the values in the access column that the user is authorized to view.
The data source is filtered by these values to generate the Connector output, i.e. what the user sees. The access column name provided in the stored procedure output must match that of the data source.
In the example below, the user can view sites A and B - other sites are excluded from the Connector output. The access column in this instance is "Site".
Fig 2: Access Control example
Please note that the Access Control properties can only be configured with System Variables.