Defining a Microsoft SQL Security Policy

You can create a new security policy or modify an existing security policy in Tidal Automation that includes the authority to add, edit, view and delete Microsoft SQL jobs and events. In the Security Policy Definition dialog, there is an MSSql Jobs and MSSql Events category.

To grant access privileges:

1. Click Security Policies in the Navigation pane to display the Security Policies pane.

2. Click a security policy for the Microsoft SQL job privileges and double-click it to display its Security Policy Definition dialog.

3. Scroll down the list of function categories and double-click the MSSql Events or MSSql Jobs category to display the available functions.

4. Click the desired job privileges, then click OK. A check mark appears next to the MSSql function category indicating that one or more functions are selected within the category.

   If needed, different security policies with varying authorized functions can be created to provide different levels of access for a variety of users.

   For more information about the Security Policy Definition dialog, refer to Users in the Tidal Automation User Guide.