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