Oracle GoldenGate requires a database user account. Create this account and assign privileges according to the following guidelines.

• 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, or operate as, the Oracle GoldenGate database user.

• 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 database)

  • Replicat (target database)

  • DEFGEN utility (source or target database)

• The Extract process requires permission to access the source database. Do one of the following:

  • Grant System Administrator privileges.

  • Assign a user name with replication_role . The command to grant replication role is either:

    sp_role 'grant', replication_role, Extract_user

    Or

    use dbname grant role replication_role to Extract_user
    

  Note:

  Specific DDL or DML operations may require the use of both sa_role and replication_role.

• The Replicat process requires connect and DML privileges on the target database.