Security context of a trigger

• Arsh

  SSCertifiable

  Points: 6345

  More actions

  June 28, 2018 at 3:58 am

  #363740

  Hi All,
  Would be great if any body can advise what security context a trigger runs using , once its fired. Thank you in advance.

  Best Regards.,
  Mohammed Arshad

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  June 28, 2018 at 4:25 am

  #1995585

  It is the same as if the user called a stored proceeure. That is ownership chaining applies etc.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]