July 30, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Reply To Message:
Posted By n/a on 10/10/2001 11:52:00 AM
Subject: deny truncate table?
Message: 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.
UserName: 
Subject:  deny truncate table?
Body:
  
Show Replies:


ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use