ACL based open transactions in replication environment

A computer-implemented method comprising:

• receiving, by one or more processors, in a data replication system where data is being replicated from a source database to a target database, a transaction log identifying a plurality of open transactions for which the data replication system is waiting to complete before replicating to the target database;
• determining, by one or more computer processors, a database user that initiated a first open transaction, wherein the first open transaction is an earliest open transaction in the transaction log;
• querying, by one or more computer processors, one or more tables of the target database corresponding to the one or more tables of the source database associated with the first open transaction, to determine whether the database user has access privileges for the one or more tables of the target database;
• upon determining that the database user does not have access privileges for the one or more tables of the target database, dynamically skipping, by one or more computer processors, replication of the first open transaction to the target database, such that the data replication system no longer waits for the first open transaction to complete, wherein the dynamic skipping includes discarding, from the transaction log, all entries related to the first open transaction, and identifying, in the transaction log, a second open transaction as a next earliest open transaction;
• and
• upon determining that the database user has access privileges to one or more tables of the target database corresponding to one or more tables of the source database associated with the second open transaction, replicating, by one or more computer processors, the second open transaction to the target database once the second open transaction completes.