What Privileges and Permissions Are Required?

Make sure you have the required privileges and permissions for data replication.

To replicate data, you must have the BI Service Administrator application role or some other role that includes BI Service Administrator.

For Oracle Database, to replicate into the user’s own schema, the user needs the following privileges :

• CREATE SESSION

• CREATE TABLE

For Oracle Database, to replicate data into other schemas within the target database, the user needs all of the following privileges:

• CREATE ANY TABLE

• SELECT ANY TABLE

• ALTER ANY TABLE

• COMMENT ANY TABLE

• INSERT ANY TABLE

• UPDATE ANY TABLE

• DELETE ANY TABLE

• DROP ANY TABLE

• CREATE ANY INDEX

• ALTER ANY INDEX

• DROP ANY INDEX

• ANALYZE ANY