SQLI_LOGIN

System-wide variable that refers to the Login (LOGIN) object of type DB that contains the crerentials (user name, passsword) of the database user that is used for executing SQLI and SEC_SQLI VARA objects.

Usually, the connection between the AE and the AE database is established as defined in the ODBC section, keysqlDriverConnect of the AE's INI file. The user that you specify there needs full permissions for all AE processes to work properly. This is the database user that is used when executing SEC_SQLI or SQLI VARA objects.

You can configure the system to use a different database user with less privileges to access the AE database when executing SQLI and SEC_SQLI VARA objects. You do so by defining a DB Login object that contains the credentials of the AE database user and by specifying that Login object in the SQLI_LOGIN key of the UC_SYSTEM_SETTINGS variable. If both prerequisites are true (the DB Login object exists and it is defined in the SQLI_LOGIN variable), the specified database user is used to establish the connection. This adds an extra security layer by restricting the access rights of the database user to, for example, just read-only. This ensures that SQLI and SEC_SQLI VARA objects can read data from the database but cannot modify or delete it.

  • Allowed values: Name of the Login object that contains the database user credentials.

  • Default value: Not applicable. If this key exists in UC_SYSTEM_SETTINGS and contains a valid value (the name of the Login object), the user/password specified in the Login object is used to establish the connection to the database. Otherwise (the key is not defined, the Login object does not exist), the connection specified in the AE's INI file (section ODBC) is used.

  • Restart required:

Important! The specified database user is used to establish the connection only if the following is true:

  • The Login object of type DB exists and contains the necessary credentials to access the database (user name and password) AND

  • The SQLI_LOGIN key is defined in UC_SYSTEM_SETTINGS AND

  • The value in SQLI_LOGIN points to the DB Login object.

Otherwise, the connection specified in the AE's INI file (ucsrv.ini) is used.

See also:

Securing the Database