Security requirements
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)