CLOSE_USER_SESSIONS

Stops the session for a user, rolls back any transaction currently running, and closes the connection. To determine the status of the sessions to close, query the SESSIONS table.

Running this function on your own sessions leaves one session running.

Syntax

CLOSE_USER_SESSIONS ( 'user‑name' )

Parameters

user‑name

Specifies the user whose sessions are to be closed. If you specify your own user name, Vertica closes all sessions except the one in which you issue this function.

Privileges

DBADMIN

Examples

This example closes all active session for user u1:

=> SELECT close_user_sessions('u1');

See Also