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 MAY 10, 2021

Applies to:

Oracle Data Integrator - Version 10.1.3.5.0 and later
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 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!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.