Minimum Privileges Required for the User Configured in ODI Topology Data Server Connection

(Doc ID 2404531.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Goal

What are the minimum privileges required by Oracle Data Integrator (ODI) for the data server connection user which is configured in Topology > Data Server > "Definition" tab > "Connection"?

This user is used to connect to the source, target and staging schemas. On staging, the schema user may be used to create/drop tables/views/triggers, build statistics, subscribe and reverse engineering, etc.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms