Dbvisit Replicate creates a user (or also called a schema) with a small repository in the source and target database to keep track of the replication.
The database grants and privileges required by Dbvisit Replicate are generated automatically by running the setup wizard. It The setup wizard generates all the necessary scripts that create a new database users and grant all the privileges needed. This means it is very easy to review what actual privileges are necessary prior to actually executing the scripts and issuing the privileges.
...
- grant select any table
- grant update any table
- grant insert any table
- grant delete any table
- grant create any table
- grant alter any table
- grant drop any table
- grant create any index
- grant alter any index
- grant drop any index
- grant create any view
- grant drop any view
...