[informix] connect in read only

[davidb]

Hello,
I see that it's supported by dbeaver 1.1.0, but I don't see this feature in GUI on v1.5.5, nor in help.
Thanks

[davidb]

I try to set access=read only in connection properties of Informix driver
It doesn't work, I can update data.

[davidb]

In fact, I don't think there is this connection property for informix jdbc.
Maybe the solution is like dbvis
http://www.dbvis.com/products/dbvis/doc ... ocId187833
Allow only SELECT statement and deny the others.
But I don't see this feature in dbeaver...

[Serge]

Currently DBeaver doesn't support read-only connections feature. If JDBC driver has some specific option which makes connection read-only you can use it but there are no client-side restrictions.
I fact this feature was never supported. So I guess what do you mean when say "I see that it's supported by dbeaver 1.1.0"...

May be we should include this feature in feature list. But I'm not really understand why this feature can be so usefull..

[codebling]

I think this would be a nice feature also. I often have to connect to other people's databases for diagnostics and it's just nice to know that I can't modify anything by accident.

[codebling]

Hey, awesome! I saw that the new release has "Read-only connections support"! How do I use it ?

[codebling]

Ah, I found it. It's the last page of the connection settings. I was trying to edit a connection and I forgot there was another page of settings. Now there are tons of features on the last page! Anyway, it works great! Thanks!