REad only on oracle

[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

[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..

[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.

[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.