1. Using Oracle GoldenGate Classic Architecture for Non-Oracle Databases
  2. Using Oracle GoldenGate for NonStop SQL/MX
  3. Preparing the Database for Oracle GoldenGate
  4. SQL/MX Access Privileges

SQL/MX Access Privileges

Dedicate an NSK user (groupID.userID ) or OSS alias userID to Oracle GoldenGate. This user requires the following access privileges at the SQL/MX data level:

  • table

  • view

  • stored procedure.

Access privileges are granted through the SQL/MX command interface with a GRANT statement. For more information on the GRANT command, see the SQL/MX documentation.

Parent topic: Preparing the Database for Oracle GoldenGate