SQL 2000 table deleted...

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

.