Using COPY or RESTORE to Migrate the Row Level Security Setup to Another System - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-04-05
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantageā„¢

When migrating the row level security setup from one system to another, a COPY of the SYSLIB database containing all the constraint UDFs automatically re-assigns new internal function IDs to the UDFs on the target system. These re-assigned IDs no longer match the IDs stored in DBC.ConstraintFunctions copied over to the target system during the migration.

Prior to migrating row level security tables to the target system, you must re-assign the UDFs in each constraint on the target system, using the procedures in Altering or Dropping CONSTRAINT Objects, as follows:

  1. Use ALTER CONSTRAINT to drop all UDFs from each constraint.
  2. Use ALTER CONSTRAINT to re-specify the UDFs in the CONSTRAINT object. The ALTER CONSTRAINT statement then inserts the corresponding rows in DBC.ConstraintFunctions with the newly assigned function IDs.