Monitoring User
Describes the user used for monitoring in ProSync Manager.
Monitoring User
Monitoring User is a user that must exist in both SRC DB and TAR DB in order to use synchronization monitoring and other features in ProSync Manager.
Features
Stream Registration
This is required when making a connection to ensure that the DB information entered during Stream registration is correct. This is required to check the cluster status to get additional information from the DB.
Instance Monitoring
This is required to retrieve the SRC Current Time and Last Commit Time, which are metrics that allow the users to check if synchronization is working properly on each instance.
Adding a dynamic synchronization table
This is required to retrieve Schema, Table, and Column information that exists in each DB when adding a dynamic synchronization table.
Integrity Check
This is required when connecting to each DB and comparing data during integrity check.
Monitoring User creation
The Monitoring User must be created by the user directly in each DB, and the created User must be registered when registering Stream.
The Monitoring User requires the following permissions
TIBERO
CONNECT
SELECT ANY TABLE
SELECT ANY SEQUENCE
SELECT ON SYS._DD_COL
SELECT ON V$DATABASE
SELECT ON V$VERSION
SELECT ON V$SESSION
SELECT ON GV$INSTANCE
ORACLE
CONNECT
SELECT ANY TABLE
SELECT ANY SEQUENCE
SELECT ANY DICTIONARY
SELECT ON V_$DATABASE
SELECT ON V_$VERSION
SELECT ON V_$SESSION
FLASHBACK ANY TABLE
SELECT ON GV_$INSTANCE
Last updated