Minimum Privileges Required for the User Configured in ODI Topology Data Server Connection
Last updated on JUNE 01, 2018
Applies to:Oracle Data Integrator - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
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