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 [...]
grant
Managing User & Role Security with Oracle SQL Developer
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 [...]
Twitter
RSS
GooglePlus
Facebook