My Oracle Support Banner

OUA 2.5.x - Granting the Appropriate User Privilege On SYS Objects (Doc ID 2062518.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.5.1.0.3 and later
Information in this document applies to any platform.

Goal

We are seeing that GoldenGate objects status is getting changed to invalid. In order to address a security concern we revoked select access on SYS objects to public and it actually broke our GoldenGate.

What objects GoldenGate needs access to under sys schema, so that we can file and exception with the security for access to those objects by GoldenGate schema
 

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


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