Post reply

Trigger execution

  • December 29, 2005 at 2:00 pm

    #92890

    Suppose you have a stored procedure that inserts data into a table. That table has triggers that fire based on the activity in the table. The stored procedure runs under a defined security context-specifically, the one used when the stored procedure is called by an ASP page via a database connection.

    What security context does the trigger run under?

    ------------
    Buy the ticket, take the ride. -- Hunter S. Thompson

  • December 29, 2005 at 2:10 pm

    #612052

    It runs under the context of the user who performed the operation (whatever user is making the database connection in the example of your ASP page). However, ownership chaining rules are still in effect.

    K. Brian Kelley
    @kbriankelley

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

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