Hello.
The option "read-only connection" don't work on all RDBMS.
Example on DB2 LUW 9.7:
SQL Warning (DataSource: DB2-OSIOTT1-EMODA; Code: 4474; State: 01000): [jcc][t4][10217][10310][4.16.53]
Connection read-only mode is not enforceable after the connection has been established.
My suggestion.
When the connection is read-only, DBeaver does not allow the following commands:
UPDATE, INSERT, UPSERT, MERGE, DELETE, TRUNCATE, CREATE, ALTER, DROP, RENAME, GRANT, REVOKE
It is simple and safe (and works with any db).
Best regards!