Oracle primary database permissions

create session

Connect to Oracle

select_catalog_role

Select from the DBA_* views

alter system

Perform redo log archive operations

execute on DBMS_FLASHBACK

Execute DBMS_FLASHBACK.get _system_change_number

alter any procedure

Start procedures for replication

create table

Create tables in the primary database

create procedure

Create rs_marker and rs_dump proc procedures

create public synonym

Create synonyms for the proc-active and shadow tables

create sequence

Support replication

drop public synonym

Drop created synonyms

select on SYS.OBJ$

Process procedure DDL commands

select on SYS.LOB$

Support LOB replication

select on SYS.COLLECTION$

Support table replication

select on SYS.COL$

Support table replication

select on SYS.COLTYPE$

Support table replication

select on SYS.CON$

Support table replication

select on SYS.CDEF$

Support replication

select on SYS.IND$

Support index identification

select on SYS.USER$

Support replication

select on SYS.SEQ$

Support sequence replication