| Author |
Messages |
|
rob
 |
| 10/10/2001 11:52 AM |
 Quote
 Reply
 Alert
|
| Is there any way that anyone knows of in SQL Server to allow individual deletes from a table but deny rights to truncate a table? I want to prevent programmers from accidentally running such a command on a non-test database but they need to be able to delete individual records. |
|
|
|
|
Chip Andrews
|
| 10/10/2001 7:36 PM |
Quote
Reply
Alert
|
| They should not be able to truncate tables in the first place unless the developers are in the db_dbowner or db_ddladmin roles or are the owner of the table.
|
|
|
|
|
|
|
|
|
|
Quick Reply |
 |
|
|
|