Grant Database Users and Privileges for TimesTen

Learn about creating database users and assigning privileges for Oracle GoldenGate for TimesTen.

• Oracle GoldenGate processes require a database user to deliver data to a TimesTen database and it is recommended to create a dedicated TimesTen database user for Replicat:

  • Replicat (target database)

  • DEFGEN (target database)

• To preserve the security of your data, and to monitor Oracle GoldenGate processing accurately, do not permit other users, applications, or processes to log on as, or operate as, the Oracle GoldenGate database user.

• For Oracle GoldenGate to replicate to a target Oracle TimesTen database, grant CREATE SESSION, SELECT, INSERT, UPDATE, and DELETE on all the target tables to the Replicat database user.

• For creating heartbeat and checkpoint tables, grant CREATE ANY VIEW to the Replicat database user.