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.

  • 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.

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

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