Unfortunately that is true, I just started here and my first order of
business is to attempt to create some order out of this chaos. Currently,
all developers log in as the same user (the user who owns all of the
tables/objects of the application). My fear is that if all developers use
this account with TOAD, they will "accidentally" drop important objects
Ideally I want to hold off on releasing TOAD to developers until I can lock down the development arena by doing as you said ... creating individual developer accounts.
I was just wondering if there is any interim solution such as a trimmed-down TOAD version.
(Unfortunately getting every developer to use an individual deverloper account is not an overnight process around here, there are dozens of cron jobs that run with a hardcoded username/password, etc.) So all of those processes will need to be changed so everyone can't just login and see the individual accounts.
Thanks for all the tips, you are adding to my arsenal of reasons that justify my objective of creating some order around here!!
From: tboss@xxxxxxxxxxxxxxxxxx Reply-To: tboss@xxxxxxxxxxxxxxxxxx To: fred_fred_1@xxxxxxxxxxx CC: oracle-l@xxxxxxxxxxxxx Subject: Re: Managing developers recommendations Date: Wed, 12 Oct 2005 16:58:27 -0400 (EDT)
Toad w/ DBA module or who have access to generic schemas that contain important data == bad.
Regular Toad with individual developer accounts, no insert/update/delete access on important tables, roles, role-level security and limits on the autoextend feature for specific tablespaces == good practice.
my one big complaint about toad: by default it comes with "autocommit off" ... which is fine, but it means every session opened to a schema in the database has an implicit "begin transaction" attached to it, so you've got lots of uncommitted/open transactions ... which can block processes from time to time.
Sounds like you've got a very unorganized dev environment going on ... your problem isn't the use of Toad, its the lack of a properly configured workspace for your programmers.
> Hi all,
> My developers (who currently just use SQL Plus) now are wanting to use
> Quest TOAD. From what I've used it in the past, it is far too powerful for
> developers. (I don't trust my developers with creating tablespaces, etc.).
> Plus, I've found that TOAD is far too easy to delete objects, etc.
> Any recommendations, etc would greatly be appreciated!
> -Fred S.
> Express yourself instantly with MSN Messenger! Download today - it's FREE!