Page 1 of 1

REad only on oracle

PostPosted: Fri Feb 26, 2016 12:55 pm
by meles
Hello, I've managed to update an Oracle table (by mistake) while the connection was supposed to be read-only.

The update took place with an sql "update table set column" statement.

Did I miss something ?


Re: REad only on oracle

PostPosted: Sat Feb 27, 2016 9:59 pm
by Serge
Oracle JDBC driver doesn't support read-only connections.
It silently sets read-only flag but still lets update/delete/insert statements to execute.
I'm afraid there is no way to make really read-only connection in Oracle at the moment..

Re: REad only on oracle

PostPosted: Sun Feb 28, 2016 8:35 am
by Serge
BTW to mark production databases as read-only it makes sense to set connection type (in connection properties).
It will color SQL editor and data editors so you won't mistake.

Re: REad only on oracle

PostPosted: Mon Feb 29, 2016 8:20 am
by meles
Thanks for your quick answer.

The database was tagged with the production flag, but a bad cut and paste resulted in this unwanted update.
I'm looking forward to ask my dbmanager to create a read only user to connect to this database.


And BTW, thanx to the dev team for this so useful piece of code.