When working with Oracle source endpoint, permissions are required for Change Data Capture (CDC) tasks by default. However, in some scenarios, we only need Full Load (FL) tasks, which require fewer permissions.
Resolution:
The minimum permissions required for a Qlik Replicate Full Load ONLY task are as follows. In this example, the Oracle account name is "FLONLYUSER":
GRANT SELECT ANY TABLE TO FLONLYUSER;
GRANT CREATE SESSION TO FLONLYUSER;
GRANT SELECT ON V_$PARAMETER TO FLONLYUSER;
In some environments, DBAs may be unwilling to grant V_$PARAMETER permission. For such cases, refer to the Alternative Resolution.
Please ensure to disable the advanced option "Automatically add supplemental logging" in Oracle source endpoint, as it is unnecessary for a Full Load ONLY task.
Internal Investigation ID(s):
#00154133
Environment:
- Qlik Replicate All versions
- Oracle All versions