SQL Server 2005 DDL Triggers on Database - Permissions?

Discussion in 'microsoft.public.sqlserver.server' started by SteveM, Feb 15, 2006.

  1. SteveM

    SteveM Guest

    As an SA, I can create DDL triggers on some of our more important
    databases. However, how do I prevent the dbo's in the database from
    deleting or disabling these triggers?
    SteveM, Feb 15, 2006
    1. Advertisements

  2. HI Steve,

    You can't do that without removing them from the dbo database role.
    How about adding them to the ddladmin and datareader and datawriter roles
    instead, and DENY the ALTER ANY DLL TRIGGER securable?
    Sune Due Moeller, Feb 16, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.