Teradata Database Message 9469 - 9469 - Analytics Database - Teradata Vantage

Message

A temporary or queue table definition cannot have any security constraint column nor refer to RLS protected table.

Explanation

Security constraints are not allowed in the definition and RLS protected table cannot be referred for global temporary, volatile, or queue table. Queue tables currently have a limitation that disallows a WHERE clause when a row is being CONSUMEd. This precludes the addition of security constraint predicates when queue table rows are consumed.

Generated By

Parser Modules

For Whom

User

Notes

None

Remedy

Redefine the CREATE, or ALTER, statement without