Specify Whether the Guest User can Execute SQL Queries

The Parameters section of the Server Configuration Tool includes a property that you can use to define whether the Guest user can execute SQL on clients that are accessing the database from this particular Geo SCADA Expert server.

To change this setting:

1. Access the Geo SCADA Expert Server Configuration Tool.
2. Expand the SQL Query Configuration branch.
3. Select the Parameters branch to display the SQL Query Parameters section.

   

4. Use the Allow guest user to execute SQL check box to specify whether the Guest user can execute SQL when accessing the database from this particular Geo SCADA Expert server.

   Either:

   • Clear the check box to prevent the Guest user from executing SQL. This is the recommended setting and is the default on new installations. This setting prevents the Guest user from executing SQL and displaying the content of Queries Lists (which include Events Lists, Historic Lists, and Objects Lists) on clients that are accessing the database via this server. Instead, when attempting to display a Queries List, the Guest user is presented with a diagnostic message with information such as:

     Access Denied

     You do not have access to the SQL

     On servers on which clients can edit SQL we also recommend that you clear the Can Edit SQL check box on the Guest user account (see Define the Global Settings for the Guest User Account).

   • Select the check box to enable the Guest user to execute SQL and display the content of Queries Lists on the clients that are connected to this server. We recommend that you only select the check box if there is a genuine requirement to provide access to Queries Lists without logging on.

     Some third-party applications such as OPC clients that do not support 'OPC Private Security' might need to use the Guest user to access Geo SCADA Expert. They require the Guest user account to have at least the Read permission so that they can access system data. This permission can be applied just to the database items that the application needs to read (see Allocating Security Permissions).

   On system upgrades, the setting of the Allow guest user to execute SQL check box is not enforced. This is by design, to enable the existing setting to remain in force after an upgrade.

5. Apply the changes to the server.
6. Perform the same procedure on any other servers on your system.