FETCHUSERIDALIAS

Valid For

Extract on Oracle

Description

Use the FETCHUSERIDALIAS parameter to specify authentication for an Oracle GoldenGate process to use when logging into a database. The use of FETCHUSERIDALIAS requires the use of an Oracle GoldenGate credential store. For more information about managing credentials, refer to ALTER CREDENTIAL STORE.

Consider the following when using the parameter:

  • In Oracle AI Database 26ai and later, the privileges are granted by the OGG_CAPTURE role. In earlier Oracle Database versions, privileges must be granted using the DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE procedure.
  • SELECT privilege are required for customer tables and to allow SQLEXEC. The SELECT privilege may not be granted using DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE procedure.
  • FETCHUSERIDALIAS must be specified before any TABLE or MAP entries in the parameter file.

Default

None

Syntax

FETCHUSERIDALIAS alias
alias

Specifies the alias of a database user credential that is stored in the Oracle GoldenGate credential store.

Example

fetchuseridalias ggnorth