View the earlier version.Version 7.10

In BizTalk360, super users/administrators can grant access permissions for normal users to access the secure SQL queries section. Click here to read the article on the steps to grant access permissions to secure SQL queries section. However, providing access does not allow users to add/execute/save/delete queries. The super users need to set up Advanced user access policy for secure SQL queries to allow users to be able to operate the SQL queries. By doing this, administrators can assign only the required queries to the users instead of everything. This offers better control over the type of access that can be given to a user.

Advanced User Access Policy For Secure SQL Queries

Follow the steps as shown below to set up the advanced user access policy for a normal user:

  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 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 Next to set up the applications that the user can access in the environment
  6. Click Next to set up the permissions for the user
  7. In the Add Permissions section, select the check boxes against 'Secure SQL Query' under 'Data Access' section
  8. Click the Advanced link next to the Secure SQL Query check box
  9. In the Secure SQL Query - Advanced User Access Policy page:
    1. Query List - Select the pre-loaded queries that the user can operate on. Click Select All to allow access to all the pre-loaded queries
    2. Can Access - Select the check boxes to set up the access restrictions for the normal user w.r.t. adding/editing/executing/deleting new Secure SQL queries. The different options available are:
      • Add Query
      • Edit & Execute Query
      • Edit & Save Query
      • Delete Query
      • Export Results
  10. Click OK to save the advanced settings
  11. Click OK to save the user permissions
  12. Log in to the application with the user information
  13. Click Secure SQL Queries from the left menu bar. You will notice that the user only has access to the selected pre-loaded queries and limited access restrictions

Click the sliders to view the process of setting up the advanced user access policy for a normal user.

biztalk360 home edit user access for secure sql query advanced access policy for sql queries allow application for sql query monitoring secure sql queries advanced access policy advanced user access policy settings in biztalk360 normal user access for sql queries advanced-user-access-policy-settings-for-secure-sql-queries