Oracle 10g Create and grant privileges to the publisher
The publisher user must be created in the source and staging databases (for example, cdcproj), to serve as the Change Data Capture publisher. The publisher user grants the necessary privileges to the user so that he or she can access the source tables and perform the underlying Streams operations needed to create Change Data Capture change sources, change sets, and change tables on the staging database.
The source and staging database DBAs must grant ALL on the tables for which the publisher will be creating change tables.
"use Change Data Capture with asynchronous log without having the DBA role?"
For grants, you can try:
grant execute on sys.DBMS_LOGMNR to fred;
grant select any table to fred;
grant execute on dbms_logmnr to fred;
grant select on v_$logmnr_contents to fred;
grant select on v_$log to fred;
grant select on v_$logfile to fred;
grant select on v_$archived_log to fred;
grant select on v_$logmnr_logs to fred;
grant select on dba_registry to fred;
grant select on v_$parameter to fred;
grant select on v_$database to fred;
grant SELECT ANY TRANSACTION to fred;