'Execute as' in trigger

• Nikita-395727

  SSC Eights!

  Points: 898

  More actions

  April 21, 2010 at 11:05 am

  #142659

  We have table 'customers' in database 'CoreSystems'.

  There is an insert trigger on customers that inserts the data in 'clientsystems'.

  In stead of giving access to the accounts that can insert into the customers table, goal is to insert into clientsystems under a specific 'triggeruser' domain account (don't ask me why).

  Is it possible to use 'Execute as ' to run the trigger and perform specific actions?

  Thanks,

  Nikki

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  April 21, 2010 at 11:35 am

  #1155553

  A trigger mat have an EXECUTE AS statement per books online. However have you considered using a certificate signed sproc instead.

  Check out:

  http://www.sqlservercentral.com/articles/Security/68873/

  You could also use service broker.

  CEWII