Rules Validation | Teradata Vantage - Rules Validation - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

The following table lists the rules DBQL validates when DBQL logging begins. DBQL checks against the application name, user name, and account string to validate rules.

IF a… THEN DBQL …
user logs on to start a session checks the username, account string, application name, and zone ID (in secure-zoned systems) in the rules cache and also looks for this in the dictionary table.
match is found in the rules cache logs according to any options in the rules table.
match is not found in the rules cache searches for a matching user or account in the Data Dictionary.
match is found in the Data Dictionary creates an entry in the rules cache and logs according to any options in the rules table.
match is not found in the Data Dictionary creates a “do not log” rule in the rules cache but does not perform logging.
“WITH NONE” rule is found creates a “do not log” rule in the rules cache but does not perform logging.
If the account string of a session is changed via the SET SESSION ACCOUNT statement, the system ensures that any rules associated with the user and account string applies when the next query is issued from that session.