Re: SQL 2000 table deleted...

they have "public" & "db_owner" ticked on all databases except master,
model, pubs & msdb, could this be the reaoson, thye could delete
tables?

Yes. Within a database, db_owner role members have all permissions, include DROP TABLE.

Is there a better way for me to do this?

Yes. The main issue is that production deployments should be done only as part of a controlled release process. If you permit ad-hoc changes, you increase the risk of accidental changes that negatively affect production. The best approach is to promote changes only after the scripts are tested in a test environment.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"gstar" <gary.brett@xxxxxxxxx> wrote in message news:1179847822.987257.124740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
We have 2 developers who need to writes SPs, create tables etc on a
daily basis but this monring they deleted 2 tables form our liver
server by mistake. We managed to get them back but I would like to
prevent this happening again.

I originally created a login called SGP_DEV_TEAM and they log on using
that account. Today I noticed that in the properties of this login
they have "public" & "db_owner" ticked on all databases except master,
model, pubs & msdb, could this be the reaoson, thye could delete
tables?

Is there a better way for me to do this?

Thanx

Gary


.