Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql Developer 2.1 editing views

eladnerMar 3 2010 — edited Mar 4 2010
One user reported that she has two separate schemas, each with their own connection. In one connection, user can open the "View" tree, right click on a view and select 'Edit' and things happen as you'd expect. In the other connection, however, right clicking does not show the 'Edit' item in the context menu, and when clicking on the view, the 'Edit' button is grayed out.

I've verified that both users have identical grants and the views in question are definitely views in each respective schema, so I can't find a database or privilege reason that the user can't edit views in the second schema.

As a side note, viewing the view DDL and copy/pasting the definition into a SQL Worksheet allows the user to change the view. Strange that the edit buttons aren't visible or clickable, though.

Any thoughts? How do I submit an official bug report?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2010
Added on Mar 3 2010
1 comment
910 views