My Oracle Support Banner

Minimum Privileges Required for the User Configured in ODI Topology Data Server Connection (Doc ID 2404531.1)

Last updated on MAY 10, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 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

To view full details, 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 a vibrant support community of peers and Oracle experts.