• 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