Home Forums SQL Server 2008 T-SQL (SS2K8) DDL Trigger to Track All Database Changes? Permissions RE: DDL Trigger to Track All Database Changes? Permissions

  • January 22, 2018 at 10:52 am

    #1976763

    Steve Jones - SSC Editor - Monday, January 22, 2018 9:38 AM

    GRANT INSERT ON dbo.DBSchema_Change_Log TO PUBLIC
    GRANT CONNECT TO guest

    This is the easiest way. I am , in general, not a fan of granting  rights to public, but in this case, this is probably OK. I enable guest, and then anyone maps over to guest and data is inserted.

    Hi Steve. This article suggests that SELECT is required, in additional to INSERT, on the log table. Can't see why, though.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.