I have a trigger in Database A on table A which does an update in database B on table B. But it is failing due to permissions. When i do an update on Table A in database A, it should do an update on table B in database B. Table A is being updated by application for which i don't know which service account does the update on table
A.In this case what permissions do i need to provide on the trigger so that it successfully updates on Table B when table A is updated. Any help would be much appreciated
You will need to find out which login is updating Database A, then apply the necessary permissions to Database B. Unless of course you want to grant every login write permissions to Database B? Are triggers what you really need, would replication not be a better option? Without some context about the actual needs would be had to say which would be better.