SHOW QUERY LOGGING Syntax Elements - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

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
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

account_specification

ALL
All users and all accounts.
ALL ACCOUNT = 'account_name'
ALL ACCOUNT = ('account_name ' [,...])

All users with this account or accounts.

If a matching rule is not found, then Vantage returns the rule for all users and all accounts.

user_name_1

The user or users.

If a matching rule is not found, Vantage returns the rule for all users and all accounts.

user_name_1 ACCOUNT = 'account_name'
user_name_1 ACCOUNT = ('account_name ’ [,...])

The user with this account or accounts.

If a matching rule is not found, Vantage searches for a matching rule in the order indicated and returns the first match that it finds.

  • User name and all accounts.
  • All users with this account or accounts.
  • All users and all accounts.
user_name_2

The user or users.

If a matching rule is not found, Vantage returns the rule for all users and all accounts.

database_name
the database or databases.

application_specification

APPLNAME = ‘application_name
APPLNAME = (‘application_name _1’, ‘application_name_2

the application or applications.