SQL Select String functionality is no longer recommended and may be removed in a future release. It is strongly recommended that Unity Scripts be used instead of SQL Select Strings. In all cases where SQL Select Strings are used until port to Unity Scripts is possible, the following considerations are strongly recommended:
-
A read-only user account with the most restrictive privileges must be used for access to an external database.
-
SQL Views should be created in the external database, if supported. SQL Select Strings should be executable against these SQL Views only.