Re: SQL 2000 table deleted...
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 22 May 2007 22:29:15 +0000 (UTC)
gstar (gary.brett@xxxxxxxxx) writes:
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?
db_owner is certainly too heavy duty. If they really need to create
tables in a production database (that's sounds bad to me), you could
grant them CREATE TABLE, but not db_owner rights. Then they would be
able create tables with themselves in their own schema. This is a little
messy in SQL 2000 where owner and schema is always the say, so if your
users are Jack and Jill, Jack can create Jack.sometable and Jill can
create Jill.someothertable, and everyone would need to refer them as
Jack.sometable etc.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: SQL 2000 table deleted...
- From: gstar
- Re: SQL 2000 table deleted...
- References:
- SQL 2000 table deleted...
- From: gstar
- SQL 2000 table deleted...
- Prev by Date: Re: Public Role for SQL 2000
- Next by Date: Re: Read-Only table?
- Previous by thread: Re: SQL 2000 table deleted...
- Next by thread: Re: SQL 2000 table deleted...
- Index(es):
Relevant Pages
|
|
