Looking at how all this stuff is being exposed through OCI, I became even more eager to find out what kind of privileges do you require on the database side in order to be able to use these. The first step was to try and run the Extract process with stripped out privileges which thankfully resulted in the following error:
2011-04-05 20:10:36 ERROR OGG-00446 Opening ASM file +DATA/ora11gr2/onlinelog/group_3.258.743164441 in DBLOGREADER mode: (1031) ORA-01031: insufficient privilegesNot able to establish initial position for sequence 398, rba 1040
.At least there is something but what exactly is it? GoldenGate’s documentation (should I add “as usual?”) doesn’t mention anything in that regards so I had to figure that one out on my own.
After some back and forth I was able to eventually discover the privilege which makes it all possible — it’s select any transaction.
Alas it is not documented to play this role but now you know anyway.