Using COPY and RESTORE After a Constraint Change - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantageā„¢
Changing or deleting name:value pairs in a CONSTRAINT object after tables that contain the corresponding constraint column are archived may result in incorrect or unpredictable row level protection. Addition of new name:value pairs without changing existing constraint parameters does not have these unpredictable effects.

If the system determines that the constraint definition has a later timestamp (due to change) than the archive copy of the data used to COPY or RESTORE a row level security table, it issues a warning: Restored/Copied data table security may be compromised because a security constraint is inconsistent between the backup and disk. The COPY or RESTORE operation is allowed to complete, but security may be compromised.

Make sure you understand the possible security effects before you COPY or RESTORE a row level security table.