Data Replication

 View Only
  • 1.  CDC User Privilege Setting

    Posted Mon July 12, 2021 02:09 AM
    May i know cdc able to set the privilege for different user ID to perform the deletion from source and reflect to target or deletion from source but not reflection to target ?

    ------------------------------
    data icons
    ------------------------------


  • 2.  RE: CDC User Privilege Setting

    Posted Mon July 12, 2021 02:31 AM
    Hello

    What are the source and target platforms and databases? The privileges required depend totally on these details.

    You can find the CDC documentation on line at About CDC Replication

    If you browse this link you may find the answer to your question 

    Regards

    Robert

    ------------------------------
    Robert Philo
    ------------------------------



  • 3.  RE: CDC User Privilege Setting

    Posted Tue July 13, 2021 03:14 AM
    The source and target platforms is Oracle 19c Database Enterprise Edition Release. Our team need to create an user who can do the deletion at source but not reflected to target, while other users are able to do deletion source and reflected target. As we know, we can restrict data deletion at source not to be reflected at target based on table setting not controlled by user.
    For such requirement, can it be done? If can, kindly provide some guidance.

    ------------------------------
    data icons
    ------------------------------



  • 4.  RE: CDC User Privilege Setting

    Posted Tue July 13, 2021 03:33 AM
    Hello.

    It seems that you want a deletion on the source to be conditionally replicated to the target, according to the user performing the delete on the source.

    This is nothing to do with privileges but is achieved with a row filter in the mapping details. &USER holds the user performing the row operation on the source. So you can specify the filter to exclude (omit) for a specific user or set of users or include (select) for a specific user or set of users, according to the expression.

    The row filter expression would something like this:

    &USER = 'FRED' OR &USER = 'CHARLIE'

    Hope this helps

    Robert

    ------------------------------
    Robert Philo
    ------------------------------



  • 5.  RE: CDC User Privilege Setting

    Posted Fri September 10, 2021 02:10 AM
    Hello Robert,

    Does this method applies for all DML changes? If I wanted for it to apply the omit only on delete is it possible?

    ------------------------------
    data icons
    ------------------------------



  • 6.  RE: CDC User Privilege Setting

    Posted Fri September 10, 2021 03:15 AM
    Hello you can &ENTTYP='DL' to the row filter - e.g.

    &ENTTYP='DL' and &USER='FRED'

    to exclude all deletes done by FRED

    Regards

    Robert

    ------------------------------
    Robert Philo
    ------------------------------



  • 7.  RE: CDC User Privilege Setting

    Posted Sun September 12, 2021 09:52 PM
    Thank you so much for your help!

    ------------------------------
    data icons
    ------------------------------