How To Grant OEM Users Administration Rights to manage only One GoldenGate Instance When Multiple Instances Are Running On The Same Host? (Doc ID 2144162.1)

Last updated on OCTOBER 19, 2022

Applies to:

Goal

User has two OEM users <USER1> and <USER2> to monitor GG instances using ports XXXX and YYYY respectively. When the administrator has assigned below privileges to <USER1>

Operator any target
Edit any Parameter file
Run any OGG command
View Contents of any OGG discard file
View Contents of any OGG report file

<USER1> is monitoring and managing both the instances using XXXX and YYYY ports even though it is supposed to monitor on port XXXX alone.

Say for example, when we have remove Operator Any Target privilege to <USER1> and let the user have only below privileges

Edit any Parameter file
Run any OGG command
View Contents of any OGG discard file
View Contents of any OGG report file

Then <USER1> is monitoring GG instance using XXXX fine but unable to Manage them ( not able to stop, start or edit parameter file)

Solution

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