This discussion is archived
4 Replies Latest reply: Nov 8, 2012 12:28 PM by Jeff Smith SQLDev PM RSS

3.2.09 Edit view action bug

669559 Newbie
Currently Being Moderated
Using the "Edit..." action from the popup menu on a view is dangerous.

Try this:

create or replace view test_view(id_col)
as select null id_col from dual;

grant select on
test_view to <any_role>;

Edit the view, changing f.ex. null to 1: "as select 1 id_col from dual"

Select privilege is gone!

Seems like behind the scenes the view is dropped and recreated instead of using "create or replace", which does not interfere with the privileges.

Also, when trying out this example of mine, each time I ran into an error while trying to update the view via this dialog (such as a missing column alias) the view had been dropped.

This edit "feature" should be removed, it is quite dangerous in it's current state.

Edited by: Björn Darri on Oct 26, 2012 4:37 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points