Security context of a trigger

  • Arsh

    SSCertifiable

    Points: 6031

    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: 23803

    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]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply