Page 1 of 1
REad only on oracle

Posted:
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 ?
Thanks
Re: REad only on oracle

Posted:
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

Posted:
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

Posted:
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.
Regards
And BTW, thanx to the dev team for this so useful piece of code.