The example below is intended to demonstrate one or more features or methods and is presented as a configuration example only. Schneider Electric assumes no liability for the use or application of this example or any portion thereof.
Starting in ClearSCADA 2017 R3, an extra security setting was added, that will allow or not users to edit SQL queries.
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), you can set it on the User object > General form:
If the availability of the Edit Query option is restricted on a per server basis on your system, you can set it on the Server Configuration tool > SQL Query Configuration > Parameters form:
Released for:Schneider Electric Canada
