Page 1 of 1

[informix] connect in read only

PostPosted: Tue May 01, 2012 1:26 am
by 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

Re: [informix] connect in read only

PostPosted: Tue May 01, 2012 3:16 am
by davidb
I try to set access=read only in connection properties of Informix driver
It doesn't work, I can update data.

Re: [informix] connect in read only

PostPosted: Tue May 01, 2012 5:25 am
by 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...
:shock:

Re: [informix] connect in read only

PostPosted: Wed May 02, 2012 11:51 am
by 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..

Re: [informix] connect in read only

PostPosted: Tue May 22, 2012 4:26 pm
by 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.

Re: [informix] connect in read only

PostPosted: Wed Jul 11, 2012 10:07 pm
by codebling
Hey, awesome! I saw that the new release has "Read-only connections support"! How do I use it ?

Re: [informix] connect in read only

PostPosted: Thu Jul 12, 2012 1:49 pm
by 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!