SET SESSION ACCOUNT Examples | Teradata Vantage - Example: Setting the Account to Change Resource Charges for a Session - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

User A, employed in the Marketing Group, has the default account ‘$M0+MKTG&S&D&H’. The user wants to change to the FIN1 account to charge the system resources used to generate the monthly finance report to the Finance Group.

SET SESSION ACCOUNT=‘$M0+FIN1&S&D&H’ FOR SESSION