GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate: filter/prevent replication from a specific user account?

edited Oct 31, 2014 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center