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)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!