How modify multiple database table when modify or delete user

I assume the use-case is for provisioning from OneIM to the target database. In that case, you need to define custom data operations.

https://support.oneidentity.com/technical-documents/identity-manager/8.1.3/native-database-connector-user-guide-for-connecting-sql-server-databases/2#TOPIC-1477046 "Define data operations"

Could you kindly give me some example for reference and some troubleshooting hints, Please help, very thanks~~

If you need to execute an update followed by an delete in your MSSQL target database, you might want to provide a stored procedure in that database that is doing exactly that and then use the pattern based strategy to call that SP as show-cased in the sample of the documentation.

If you need to execute an update followed by an delete in your MSSQL target database, you might want to provide a stored procedure in that database that is doing exactly that and then use the pattern based strategy to call that SP as show-cased in the sample of the documentation.

Thanks Markus, I try with script based and got some feeling~~