OUA 2.5.x - Granting the Appropriate User Privilege On SYS Objects
Last updated on OCTOBER 02, 2015
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 188.8.131.52.3 and later
Information in this document applies to any platform.
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
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