Quickly copying objects to a new environment is easy in SQL Developer. You simply go to the object in the tree and access the SQL page.
However a few of our users were complaining that we weren’t including the object privileges that had been GRANTed in the SQL script. So after re-creating the object in another system, they would have to look at the Grants page and manually recreate those scripts.
So in version 3.2, you can now include the GRANT statements in your object scripts.
But Wait, I Still Don’t See My Grants!
There’s no trick here. But, you must first tell SQL Developer what you want included in your scripts. Whenever SQL Developer generates a script for an object, it consults the preferences.
Another very small change that I believe will vastly improve the end user’s experience – and save you a lot of time!