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

DB Type	Required privilege
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