Try OpenEdge Now
skip to main content
SQL Development
Change Data Capture : CDC Table Security
 

CDC Table Security

Change table and Change Tracking tables are created from OEM or the OEE Data Admin tool. SQL restricts all DDL operations on Change table and Change Tracking table and cannot perform DDL operations like ALTER TABLE, DROP TABLE, CREATE TABLE, CREATE INDEX, DROP INDEX, TABLE Rename on the Change table and Change Tracking table. However, some DML operations are allowed for Change table and Change Tracking table. The following table summarizes the operational access of OE SQL to the Change table and Change Tracking table:
Operation
Change Table
Change Tracking Table
INSERT
Not allowed
Not allowed
DELETE
Allowed
Allowed
UPDATE
Not allowed
Allowed only on “_User-Misc” field. Not allowed on all other fields
SELECT
Allowed
Allowed
Note: If the source table is a Multi-tenant table, only tenants with access to Multi-tenant tables can access those table for Change data.