View the latest version.Version 8.0

In BizTalk360, administrators (super users) can set up fine grained authentication and authorization policies for both individual users and NT groups through the user access policy mechanism. By setting up the access restrictions, only authorized users will have the capability to access specific areas of the application. This can be done through the "Permissions" screen in the user access policy section under "Settings".

Setting Up The Access Permissions For Custom SQL Queries Section

To set up the access permissions for a user, follow the steps as shown below:

  1. Log in to the application (as a Super User)
  2. Click the Settings icon at the top of the page
  3. Click User Access Policy from the left menu bar
  4. Click Add New to add a new user to the system. Click here to view the steps in adding a normal user. Click Edit to modify an already existing user information.
  5. Click => to set up the applications that the user can access in the environment. 
  6. Click => to set up the permissions for the user
  7. In the Permissions section, select the check boxes against 'Custom SQL Query' under 'Can Access Data' section
  8. Click OK to save the settings and create the user
  9. Log in to the application with the user information
  10. In the left menu bar, user will see only the Custom SQL Queries and few applications for which he has access

By providing access to Custom SQL Query section (under Permissions in User Access Policy), normal users will not have the permissions to view the pre-loaded queries and the ability to add/edit/execute/save/delete queries. Super Users must configure the Advanced User Access Policy for Custom SQL queries to allow users to be able to perform the actions.

Click the sliders to view the process of granting permissions for users.