1 post tagged “affect db objects”

This morning a colleague and I discovered that it is possible to modify database objects (Tables, Views etc...) via the Eclipse DB Browser perspective.  Up until now we thought that this was "read-only" functionality.

It turns out that if you open the select statement of a view, for example, change the select statement for whatever reason, and then save, upon saving it will actually modify the view in the database.  You may say that this sounds obvious, and it sounds as if it is, however up until now we have assumed that it's not possible to modify these objects via the DB Browser.

The main problem here is that you may inadvertently modify a view in Oracle / SQL Server, and then break application functionality and/or unit tests.

To get around the problem, create a read only user account in the database and use that to connect via DB Browser.