Set Up Access to SQL Where Clause Search

You can assign a user to the security role that has access to SQL Where Clause search functionality.

Warning: When you assign SQL Where Clause search access to a security role, all users assigned to that role will have access to every field in the database. Consider carefully which types of users should be included in a security role with access to SQL Where Clause searches.

To set up security role access to SQL Where Clause searches:

  1. In the Navigation pane, select Settings > Security > Roles.
  2. On the Roles form, select a role.
  3. In the Additional Search Options section, select the Allow Access to SQL Where Clause option.
  4. On the Access Rights tab, set the Functional Area option to include those areas in which members of the role can execute SQL Where Clause searches.