Selecting the DDL tree page and setting the SQL Statement radio control to "Create" does change the code in the SQL statement to "CREATE OR REPLACE VIEW", but selecting OK on the Edit View dialog DOES NOT run this code. It still drops the table and recreates it - which causes all privileges to be lost.
The default for editing a view should be to "CREATE OR REPLACE VIEW".
Please consider fixing the Edit View dialog to:
- Default to the "CREATE OR REPLACE VIEW" logic
- When DDL tree page is selected, the code that is displayed in the SQL Statement should be executed when the "OK" button is selected.
I agree with the original posting that using the "Edit..." action from the popup menu on a view is dangerous. It has bitten us quite a few times.