Permissions

The user specified in the connection string must be granted the following privileges granted in the Oracle database:

• 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)