Post reply

trigger security

  • April 30, 2013 at 9:20 am

    #292771

    I have a group of users with ddl_admin previalges on databases which i want to continue but how can i preven them from making changes to a particualr trigger on that database?

  • April 30, 2013 at 1:56 pm

    #1611395

    You can DENY ALTER on the table but in addition to preventing changes to the triggers on that table it also prevent them from adding columns to the table, modifying any constraints, enabling/disabling triggers, etc.

    USE YourDatabaseName;

    GO

    DENY ALTER ON dbo.YourTableName TO TheDatabaseUserName;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply