EEE SQL Query Executor
From EnablerWiki
As of EEE version 1.84.09 a new SQL Query Executor function is available within EEE.
This screen allows users to run ad-hoc T-SQL queries against the EEE database using an appropriate SQL authentication credential.
Although EEE issue warnings if the query text contains specific keywords, EEE does not analyse the syntax of the query nor attempt to prevent execution of destructible queries.
As such, the following security considerations are recommended:
- Disable the screen for all but specific users who have knowledge of creating and running T-SQL queries. This can be done via user privileges.
- Set up the SQL authentication login with the minimum permissions required (see below).
- Use a complex password for the SQL login in order to improve security.
