Learn how to create database users for the processes that interacts with the database, assign the correct privileges, and secure the credentials from unauthorized use.
Assigning Credentials to Oracle GoldenGate
The Oracle GoldenGate processes require one or more database credentials with the correct database privileges for the database version, database configuration, and Oracle GoldenGate features that you are using.
Create users for the source and target database instances, each one dedicated to Oracle GoldenGate. The assigned user can be the same user for all the Oracle GoldenGate processes that must connect to a source or target Oracle Database.
CREDENTIALSTORE command usage to
manage credentials in a credential store for Oracle GoldenGate