Define the SQL Editing Settings for a User
The properties described in this topic apply both to User Forms and User Pattern Forms. (User Patterns only apply to systems on which ClearSCADA can create new User accounts automatically as part of an External Authentication process. For more information, see Create User Accounts from a User Pattern.)
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.
If the availability of the Edit Query option is restricted on a per user basis on your system (rather than per server), use the following settings to specify whether a user has access to the Edit Query option:
-
Either:
- Display the relevant User Form (to define the settings that apply to an individual User account).
- Display the relevant User Pattern Form (if applicable to your system, to define the settings that ClearSCADA is to apply to new User accounts that it might be triggered to create automatically at logon.)
- Select the General tab.
- Scroll down to the Can Edit SQL check box.
The setting of the Can Edit SQL check box only has effect providing that access to the Edit Query option and QueryPad is not restricted on a per server basis (see Specify Whether SQL Queries can be Edited using the Clients on this Server).
Either:
- Clear the check box if the user is not to be given access to the Edit Query option, or the ability to connect QueryPad to a database. This is the default on new user accounts.
Or:
- Select the Can Edit SQL check box if the user is to have access to the Edit Query option. Providing that the user has access to such Lists, they will be able to edit the SQL queries that are used in Lists other than Alarms Lists. They will also be able to use QueryPad to connect to the database in order to test SQL queries.
For information on using the Edit Query option, see Ascertain which SQL Query is Presently used by a List in the ClearSCADA Guide to Lists.
For information on using QueryPad, see Welcome to the ClearSCADA Guide to QueryPad.
We recommend that you select the check box on the User Accounts of those users that are likely to require access to the SQL that is used in built-in Queries Lists. For example, so that they can use that SQL as a basis for writing the SQL for Lists that they intend embedding in Mimics. (If the check box is not selected, they will still be able to configure the SQL for such Lists directly, using ClearSCADA's built-in Query editor (provided that their User Accounts are assigned the relevant configuration permissions and access). However, they will not be able to edit the SQL that is used in built-in Queries Lists, in order to use that SQL as a basis for writing the SQL that they require. Nor will they be able to use QueryPad to test SQL queries.)
The 'Can Edit SQL' property does not impact on a user's ability to edit SQL configuration elsewhere from a ViewX client (for example, SQL animations on Mimics). However, the User Accounts of such users have to be assigned the relevant configuration permissions and access in order for those users to be able to gain configuration access to those features and database items.
Further Information
Restrict Guest User access to the Edit Query option: Define the Global Settings for the Guest User Account.