Dbvisit Replicate creates a user (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. 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.

The following database privileges are required for Dbvisit Replicate:

Source database privileges

grant create session
grant create table
grant create view
grant create procedure
grant create sequence
grant alter database (This is only needed for initial setup purposes which issues the following command "alter database add supplemental log data". After setup this privilege can be revoked)
grant alter system (This is used to switch/archive logfile)
grant select, flashback on sys.col$
grant select, flashback on sys.tab$
grant select, flashback on sys.obj$
grant select, flashback on sys.user$
grant select, flashback on sys.ind$
grant execute on dbms_flashback
grant select on v_$log
grant select on v_$thread
grant select on v_$logfile
grant select on v_$archived_log
grant select on v_$database_incarnation
grant select on v_$database
grant select on v_$transaction
grant select on gv_$asm_client
grant select on v_$session
grant select on v_$lock

Target database privileges

grant create session
grant create table
grant create view
grant create sequence
grant create procedure
grant execute on dbms_flashback
grant select on v_$database
grant select on v_$mystat
grant select on v_$session
grant select on v_$lock
grant select on sys.user$
grant alter system
grant alter session
grants to insert, update and delete on replicated tables only

DDL replication

If DDL replication is enabled then the following grants are also performed:

Source database

grant alter any table
grant lock any table

Target database

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

Browser not supported