Privileges required

Owned by Arjen Visser
Last updated: Dec 11, 2013
2 min read

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