Specify Whether SQL Queries can be Edited using the Clients on this Server

You can restrict the ability to edit the SQL queries that are used in Lists other than Alarms Lists. This is done by restricting the availability of the Edit Query option on such Lists. Access to this option can be restricted on either a per server, or per user, basis. When access to the Edit Query option is restricted, the restriction also extends to QueryPad, the SQL query diagnostics tool that is supplied with ClearSCADA. When the restriction is in place, users will be unable to connect QueryPad to the database.

To specify whether the Edit Query option is available on the clients that connect to ClearSCADA via this server:

1. Access the ClearSCADA Server Configuration Tool.
2. Expand the SQL Query Configuration branch.
3. Select the Parameters option to display the Parameters section.
4. Either:
   1. Select the Allow Clients to Edit SQL check box to make the Edit Query option available to those users whose User Accounts provide access to that option on Lists other than Alarms Lists.
   2. Use each user's User Account to specify whether individual users are to have access to the Edit Query option and QueryPad (see Define the SQL Editing Settings for a User).
   3. Use the Guest User account to specify whether users that access ClearSCADA without logging on are to have access to the Edit Query option and QueryPad (see Define the Global Settings for the Guest User Account).

   Or:

   • Clear the Allow Clients to Edit SQL check box if no users are to be given access to the Edit Query option on such Lists, regardless of the settings on their User Accounts. Likewise, the ability to connect QueryPad to a database will also be denied.

     

5. Apply the changes to the server.
6. The above setting applies to all clients that connect to ClearSCADA via this server. On multi-server systems, remember to configure the other servers accordingly. For example, you might want to retain the same restriction on the clients, regardless of the server via which they connect to ClearSCADA. Alternatively, you might want to configure your servers such that access to the Edit Query option is permitted from some servers, but not from others.

   Consider whether you want to provide access to the Edit Query option and QueryPad from at least one of the servers on your system. With such servers, you would then restrict/allow access to the Edit Query option on a per User Account basis. You could use this to provide access to the Edit Query option for those users that are likely to require access to the SQL that is used in built-in Queries Lists. Such users will also be able to connect QueryPad to the database in order to test SQL queries.

    

   On a particular system, the Allow clients to edit SQL check box is used to:

   • Provide access to the Edit Query option and QueryPad for clients that connect to ClearSCADA via Permanent Standby servers. (Only those users whose User Accounts provide access to the Edit Query option are given access to that option from Lists other than Alarms Lists. Likewise, only those users will be able to connect QueryPad to the database to analyze SQL queries.)
   • Deny access to the Edit Query option for clients that connect to ClearSCADA via Hot Standby servers, including the Main server.