KILL USER - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

The KILL USER command terminates all logged on sessions for the specified user name restricted to the host group of the gateway. KILL USER aborts any active requests on those sessions and logs the sessions off.

Syntax

{ KILL | KI } { USER | US } user_name
user_name
Name of the user.
To list the possible values for user_name, use DISPLAY GTW or DISPLAY SESSION.

Usage Notes

Aborting an outstanding request can take a significant amount of time. Killing a session or a user’s sessions does not necessarily free up the resources of those sessions immediately.

Before using the KILL USER command, select the host group from which the session is running using the SELECT HOST command. For more information, see SELECT HOST.

The KILL USER command leaves an audit trail in the gateway log files, which shows the vproc that the kill was issued on and the session number of the user being killed. Because the attempt might be denied by Teradata Database, only the attempt is logged:

Gtwglobal issued kill command:
gtwassign.c @3205 (867): Fri Apr 18 13:39:01 2008
VprocId: 8193 Session Number: 1009

Example: Terminating all sessions for a specified user

kill us perm01
User PERM01 has 1 session killed
1005