Object Browser Additional Info

[bschleic]

Is there a way to have the object browser automatically include additional information, such as grants and public synonyms, when I view or edit an object?

 

[Marco Kalter]

I'm not quite sure what you mean. Can you elaborate?

 

[bschleic]

I'm currently working to update a view and when I right-click on the view in the object browser and select edit I get a create or replace view statement that I can make changes to and run to update the view. What I'd like to see is when the statement is generated the view's grants and synonym are automatically included. Similar to what happens when you use the Export User Objects tool, but without the extra steps of actually using it.

 

[Marco Kalter]

I see. There is currently no option for this. I have added this to the list of enhancement requests.

 

[bschleic]

Great, and thanks for the quick response. I am new to PL/SQL Developer after using another tool for my past jobs and this makes me less nervous about making the switch.