Home Forums SQL Server 2005 SQL Server 2005 Security Deny OR Revoke "Drop object" Permission RE: Deny OR Revoke "Drop object" Permission
K. Brian Kelley
SSC Guru
Points: 114562
More actions
August 21, 2009 at 6:25 pm
#1043208
You also have to worry about ALTER TABLE. Here I explain the issue and why the DDL trigger works:
Granting limited permissions to create views in another schema in SQL Server - Part 2
K. Brian Kelley@kbriankelley