15.10 - Example: Setting the Account to Change Resource Charges for a Session - 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

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