Re: Sql Developer
- From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- To: DennisCutshall@xxxxxxxxxxxxxxxxxx
- Date: Tue, 12 Jun 2007 13:01:40 -0600
Dennis,
We recently switched all our developers from TOAD to SQL Developer for
economic reasons. To date, they haven't found any functionality lacking in
SQL Developer that they had in TOAD that was critical to development
success. All the grumbling I heard was due to their lack of familiarity
with the product. Those who switched early (we gave them 3 months before
the switch) are happy with SQL Developer and have found it to be superior in
some ways. Personally, I like the query builder tool since I haven't
memorized all the column names in all the tables. Oracle patched the query
builder in April or May so a user who has privileges on another users tables
can drag and drop them in query builder. I've done some charts using the
tool as well, which simplified presentations I was giving. No need to port
the information to Xcel. I'm sure it has other interesting features, but I
haven't had as much time as I would like to play with it.
We didn't have any security issues. Passwords are strictly controlled in
production and privileges are reviewed on a monthly basis to ensure no one
was "accidentally" given privileges they shouldn't have or not granted
privileges they should have. In the development environment, developers are
restricted to the same privileges as the production schema to mimick what it
can and can't do. Our test environment is set up the same way.
Sandy
We are looking at using Oracle's SQL Developer as a development tool.
Does anyone have any experience with this product? If so, please pass on
your findings. We are particularly concerned about security. We noticed
that any user e.g. Scott, can look at many of the objects in SYS and
SYSTEM. Is this a concern, or are those normally public?
Dennis
Dennis Cutshall
Data Base Administrator
University of North Dakota ITSS
Phone: (701) 777-4109
Fax: (701)777-3978
E-Mail: DennisCutshall@xxxxxxxxxxxxxxxxxx
Other related posts:
