Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer

thatjeffsmith SQL Developer 5 Comments

Today’s Question: How do we prevent Oracle SQL Developer from dropping the grants/privileges when modifying a view. While using SQL Developer we modified a view and once saved it removed all of the user access previously set up for the view. This did not previously take place when using… Ugh. That doesn’t sound good at all. Let’s drill into this …

Managing User & Role Security with Oracle SQL Developer

thatjeffsmith SQL Developer 12 Comments

With the advent of SQL Developer v3.0, users have had access to some powerful database administration features. Version 3.1 introduced more powerful features such as an interface to Data Pump and RMAN. Today I want to talk about some very simple but frequently ran tasks that SQL Developer can assist with, like: identifying privs granted to users managing role privs …