Security requirements

A user must have the following privileges granted in the Oracle database to use an Oracle target in a Qlik Replicate task:

• CREATE ANY TABLE

• CREATE ANY INDEXES

• ALTER ANY TABLE

• DROP ANY TABLE

• INSERT ANY TABLE

• UPDATE ANY TABLE

• DELETE ANY TABLE

• SELECT ANY TABLE

• SELECT all_indexes

• SELECT all_ind_columns

• SELECT all_constraints

• SELECT all_cons_columns

• LOCK ANY TABLE (Required for the Use direct path full load option in the Advanced tab).