OUA 2.5.x - Granting the Appropriate User Privilege On SYS Objects
(Doc ID 2062518.1)
Last updated on JULY 18, 2019
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 220.127.116.11.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
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