RE: Sql Developer

This is an all too common a theme, that tools convey power. If you can do it in SQL Developer, you can do it through SQL*plus. 'nough said.    

If you're interested in the product itself I can speak some to that.  

I've been a Toad user for about 7 years. With each release it gets more and more bloated, slower and slower, and segment faults more often. Its capabilities though are massive. OTOH, SQL Developer (been using for 6 months) is much more stable, I never have it crash, it's not slow to open new windows, it's mostly intuitive, but it is young as software goes. The base capabilities are mostly there, some things don't work, things you think it should do it doesn't (yet) - I've found no gotchas though, you know, you expected it to do one thing and it did the opposite and didn't bother to tell you kinda thing. The nice thing is that the online community is pretty strong. The developers keep a bug list and future features online so you can see where the product is going and where it isn't. AND if you know Java you can extend it yourself.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Tuesday, June 12, 2007 1:05 PM
To: DennisCutshall_at_mail.und.nodak.edu
Cc: oracle-l_at_freelists.org
Subject: Re: Sql Developer  

it obeys all security you have in the db. some objects in SYS/SYSTEM are granted to public, hence are visible from other schemas. No security risk simply by using the product.

rjamya

On 6/12/07, Dennis Cutshall <DennisCutshall_at_mail.und.nodak.edu> wrote:

Hi,  

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?    

>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

--
http://www.freelists.org/webpage/oracle-l