how can i prevent a user from droping tables

[isonlyme]

Hi ,

I'm looking for a way to deny users from droping tables
in the BOL i cant find a revoke statement

if i write this:
revoke drop table to test
i get thios error
privilige DROP <object> may not ber granted or revoke

is there a way to to do this?

thanks in advanced

 

[DrSql]

Remove the dbo permissions from user and grant dbread & dbwrite.

Dr.Sql
Good Luck.

 

[mrdenny]

In SQL 2000 you have to do as DrSQL posted. In SQL 2005 you can write a DDL trigger to handle rolling back the transactions.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com