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.
Note: 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
Examples
This example closes all active session for user u1
:
=> SELECT close_user_sessions('u1');