Both the SQL form elements and the SQL queries within the rules allow you to choose a database connection. Per default the JobRouter's own database connection is available. When choosing this connection, all queries are executed in the context of the JobRouter user. They have many rights that are generally not necessary for pure queries. That is why it is highly recommended to define and use your own database connection (global or process-based) through a user with limited rights when executing SQL queries in forms or rules. This user should only be allowed to access data that is needed within a process and is only provided with the rights for the respective case (e.g. read-only).
Please note: SQL commands to external databases will be executed outside of the transaction. If you want to execute queries within a transaction in a rule, they are only integrated in the transaction when the JobRouter database connection is used.
