Data Replication

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
------------------------------


#DataReplication
#DataIntegration

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
------------------------------

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataReplication
#DataIntegration

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
------------------------------

Original Message:
Sent: Mon July 12, 2021 02:31 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataReplication
#DataIntegration

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
------------------------------

Original Message:
Sent: Tue July 13, 2021 03:13 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:31 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataIntegration
#DataReplication

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
------------------------------

Original Message:
Sent: Tue July 13, 2021 03:33 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Tue July 13, 2021 03:13 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:31 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataReplication
#DataIntegration

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
------------------------------

Original Message:
Sent: Fri September 10, 2021 02:10 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Tue July 13, 2021 03:33 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Tue July 13, 2021 03:13 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:31 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataReplication
#DataIntegration

Thank you so much for your help!

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

Original Message:
Sent: Fri September 10, 2021 03:15 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Fri September 10, 2021 02:10 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Tue July 13, 2021 03:33 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Tue July 13, 2021 03:13 AM
From: data icons
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:31 AM
From: Robert Philo
Subject: CDC User Privilege Setting

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

Original Message:
Sent: Mon July 12, 2021 02:09 AM
From: data icons
Subject: CDC User Privilege Setting

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
------------------------------


#DataIntegration
#DataReplication