Home Forums Article Discussions Article Discussions by Author Discuss content posted by Derek Colley SQL Triggers in a Security Context RE: SQL Triggers in a Security Context

  • July 12, 2012 at 4:25 pm

    #1512347

    derek.colley (7/12/2012)

    Timothy

    Good points and a trigger shouldn't be considered the principal method for securing a database. Your comments about a change log - have you considered using Kimball tables? These are the Type 2, 3, 4 and 6 tables that enable you to log changes to tables in different ways (also called Slowly Changing Dimension (SCD) tables, used in SSAS too).

    I haven't run into Kimball tables before, and a quick google search seems to lead me mostly to pages about wooden tables. Is there a reference you would recommend?

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/