Post reply

Trigger Error

  • August 6, 2014 at 11:47 pm

    #297627

    Hi

    i am inserting a record in XYZ table(DB1). Through trigger it will update ABC table(DB2).

    I am getting error when doing above thing. What are the roles to be set to user to avoid above problem.

    Thanks

  • August 6, 2014 at 11:59 pm

    #1735840

    Please post the text of the error message.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 7, 2014 at 12:03 am

    #1735842

    The server principal "DB1" is not able to access the database "DB2" under the current security context.

  • August 7, 2014 at 12:40 am

    #1735846

    I believe that the trigger executes under the same credentials as the event which fired it.

    So the users doing the inserts in DB1 also need rights in DB2.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

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