CDC : asynchronous HotLog (Same DB) --> dba role ?
olwinOct 6 2010 — edited Oct 10 2010Hi,
Sorry for my poor english.
I don't understand if publisher in asynchronous HotLog (only one DB) need DBA role or not
I read the following documentation : http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/cdc.htm#DWHSG8478
For asynchronous HotLog, Distributed HotLog, and AutoLog publishing, the staging database publisher must be configured as an Oracle Streams administrator and also be granted the CREATE SEQUENCE privilege, as follows. (See Oracle Streams Concepts and Administration for information on configuring an Oracle Streams administrator.)
At first sight I only need create sequence and Oracle streams administrator right
But just after :
- Be granted the CREATE SEQUENCE privilege
- Be granted the DBA role
- Be the GRANTEE specified in a DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE subprogram issued by the staging database DBA
--> Now i need dba role
But in the following sentence, it specifies that distributed hotlog publishing need dba role
*<<For asynchronous Distributed HotLog publishing, the source database publisher must be granted the DBA role and must be the grantee specified in a DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE subprogram.>>*
why this precision, if that is already indicated before ?
Is DBA role only need for asynchronous Distributed HotLog publishing or for asynchronous hotlot too ?