Modifying Database Objects with Eclipse DB Browser
Did you always think that database objects (Tables, views etc.) were a read-only functionality? Well, the you would be wring, as Jon Beer discovers that it is possible to modify database objects via the Eclipse DB Browser perspective.
According to Beer, if you open the select statement of a view and then save, it will modify the view in the database. He however cautions that the main problem here is that you may end up modifying a view in Oracle/SQL Server and break application functionality. He then goes ahead to give the work around for this too--create a read only user account in the database and use it to connect via the DB Browser