Database User for Oracle GoldenGate Processes

Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database:

• Extract (source SQL/MX database)

• Replicat (target SQL/MX database)

• DEFGEN (source or target database)

Table 23-1 Database user for Oracle GoldenGate processes

Privilege	Extract user	Replicat user	DEFGEN user
SELECT	X	X	X
DELETE	X
INSERT	X
UPDATE	X
REFERENCES	X