REad only on oracle

Note: please leave bug reports and feature requests on

REad only on oracle

Postby meles » Fri Feb 26, 2016 12:55 pm

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
meles
 
Posts: 2
Joined: Fri Feb 26, 2016 12:01 pm

Re: REad only on oracle

Postby Serge » Sat Feb 27, 2016 9:59 pm

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
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: REad only on oracle

Postby Serge » Sun Feb 28, 2016 8:35 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: REad only on oracle

Postby meles » Mon Feb 29, 2016 8:20 am

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.
meles
 
Posts: 2
Joined: Fri Feb 26, 2016 12:01 pm


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 18 guests