ALLBASE/SQL Reference Manual (36216-90216)

574 Chapter12
SQL Statements S - Z
TERMINATE USER
TERMINATE USER
The TERMINATE USER statement terminates one or more DBE sessions associated with
your user name or another user name.
Scope
ISQL or Application Programs
SQL Syntax
TERMINATE USER { DBEUserID
SessionID
CID ConnectionID }
Parameters
DBEUserID identifies the user to terminate all sessions for. Users currently on the
system appear in the system view SYSTEM.USER.
SessionID identifies a specific session to be terminated. Session identifiers can be
found in the system view SYSTEM.USER. One user may have several
session IDs active at the same time.
CID
ConnectionID identifies the specific connection to terminate.
Description
• Any transactions in progress in the session(s) are terminated and any changes are
backed out. Any locks still held are released, and any cursor still open is closed.
Authorization
You can terminate a session if it is your own session, or if you have DBA authority.