menu change request

[Kent]

On the context menu for packages, please change "View" and "Edit" to apply to both the package and the body. Then remove the "View package and body" and "Edit package and body" menu items. I always choose "View" or "Edit" for every other db object type, but when by habit I choose one of these for a package, it is annoying to not get the body. I have to close the new window and then select the "...package and body" menu option. It is extremely rare that I want to access a package and not the body. Thanks.

 

[Marco Kalter]

I have added a preference option for this to the list of enhancement requests.

 

[ner]

Is any way to disable the "Edit" and "Edit package and body" context menus?
I don't want to directly modify db object. Only from executing .sql files...

 

[Marco Kalter]

Yes, you can go to Tools > Preferences > Oracle/Options, and disable the "Allow editing of database source" option. You can also use the Authorization function and allow everything but specific "Objects.Edit" functions.