Re: Stored Procedures - Who is in Charge?

> > Store procedure should be written by programmer not DBA, becuase it has > to do with process not data. so programmer.But how about control. So it > has to given to DBA for creation but nor programmer. > > Programmer has to debug/test. Approval is from DBA.When a programer hand > over the SP it should be bug free, otherwise, there will be lot of > co-ordination problem with DBA > > Development - > Programmer / Project Leader / Database Expert etc.. > > Production -> DBA > I feel the issue here is a question of definition - one that has become apparent with the more current releases of Online. I don't have the current titles down pat but it looks something like: application developers - who are concerned with presenting and accepting data to a customer. DBA who owns the schema Admin who does database sysadmin The 'DBA' is thus no longer concerned with keeping the engine running, but is rather more concerned with integrity of the database. The application developer no longer has the capability to create their own tables to do 'stuff' - but has to fit their needs into a broader picture. The admin is concerned with getting peak performance and keeping the engine running. There is some overlap with the DBA - Fragmentation for example, the admin cannot do fragmentation properly without some concept of what the data is. In this model SPL creation is in the realm of the 'DBA'. This removed the application programmer from the need to have update/insert/delete permission on the tables in question - they call an SPL which does that for them. it ensures that there is only ONE place where this sort of stuff can occur - hence some better control over its functionality. my .02 cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________