Wednesday, 13 December 2017

Synchronize User Passwords between Companies with SQL Trigger

Hi Everybody,

Here want to share with you one easy way how to easily sync passwords between users in all companies in Acumatica - we can use SQL triggers.
A trigger is a special kind of code that automatically executes when an event occurs in the database server. Database Engine execute trigger when a user tries to modify data through a data using Update/Delete/Insert commands.

In our case we can catch the event when password is changed in specific company and distribute it to all other companies we need.

Code:

Have a nice configurations.

No comments: