15.10 - Example: Logging All Users Who Are Logged On Under Specific Accounts - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Log request information for AMP steps, database objects, unformatted EXPLAIN text, the request plan as an XML document, and SQL text for all users logged on under account IDs account_1 and account_2:

     BEGIN QUERY LOGGING WITH STEPINFO, OBJECTS, EXPLAIN, XMLPLAN, SQL 
     ON ALL ACCOUNT = ('account_1', 'account_2');