Database Query Restrictions in Enterprise Architect 17.2

[emiliano.davila]

Hello everyone,

We are currently testing the upgrade to Enterprise Architect 17.2 and have noticed some changes regarding database queries.

First, we observed that it is no longer possible to query the repository security tables, such as `t_secuser`, `t_secgroup`, and `t_secusergroup`, among others.

Additionally, the `Repository.SQLQuery()` method apparently only allows `SELECT` queries, meaning that it can no longer be used to execute `INSERT` or `UPDATE` statements.

We have also encountered issues when running recursive queries using expressions such as `WITH RECURSIVE`, even when they are read-only queries.

We reviewed the published change history for EA 17.2 but could not find any information related to these restrictions.

Has anyone experienced similar behavior?

Is this an expected and permanent change in the tool, or is there any configuration that would allow these operations to be enabled again?

Thank you in advance.

Best regards,

[GeordieKiwi]

These are likely to be in response to security issues that were brought to light a few months back