GoldenGate: filter/prevent replication from a specific user account?
Is there a way to filter/prevent replication from a specific user account?
We are exploring ways to prevent uncontrolled/unauthorized operations performed by a user in a replicated environment and in the scenario of an inadverdent drop on the source we would not want it replicated to target.
Is there a way to filter/prevent replication from a specific user account?
For example if user XYZ executes a drop table command(DDL), can goldengate prevent this DDL replication by having XYZ commands filtered out from its replication stream (even if the underlying objects were in the replication mapping)? (same for DML: inserts, updates, deletes made by this user)