Help - Search - Members - Calendar
Full Version: Change Data Capture
Oracle DBA Forums > Oracle > Oracle Forum
liquid
Hi!

Is there any way to use Change Data Capture with asynchronous log without having the DBA role?
I have seen this document and it says that i must have DBA role.

http://youngcow.net/doc/oracle10g/server.102/b14223/cdc.htm


Thank you
aussie_dba
See here:

http://www.praetoriate.com/10g_121.htm


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:

CODE
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;
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.