the untouchable audit table

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  February 25, 2003 at 5:47 pm

  #79724

  Is it possible to create a table in a user database that only allows one stored procedure to add rows to it? I want to create a audit/log table that is UNTOUCHABLE and don't want anybody, including the SA, to be able to modify its structure or data in any way once it is in operation.

  thanks in advance,

  Billy

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  February 26, 2003 at 7:32 am

  #449766

  No. SA can always change whatever they want. In my opinion, if you don't trust the SA, get rid of them.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter