My Oracle Support Banner

How To Set Up Database Users Other than the Schema Owner to Access the ODI Repository Tables? (Doc ID 781173.1)

Last updated on DECEMBER 27, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.5.0 to 11.1.1.9.210115 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.

Goal

In Oracle in particular, instead of using the schema owners (for example, <ODI MASTER SCHEMA> / <ODI WORK SCHEMA>) to connect to the Master and  / or Work Repositories, is it possible to set up other user accounts (eg. <SCHEMA>) to logon to Oracle Data Integrator (ODI) Repositories in order to comply with security requirements?

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.