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

Last updated on OCTOBER 02, 2015

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

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