Name
disconnect_user — Disconnect client connections of a given user
Synopsis
disconnect_user ( |
in username_pattern string
); |
Description
disconnect_user disconnects clients whose username matches the username_pattern string given as an argument, and returns an integer value giving the number of clients disconnected. This can be used after DELETE USER or REVOKE statement to make sure that the affected user has no open connections.
Parameters
username_pattern
A string pattern to match users to be disconnected. SQL wildcards including Virtuoso extensions may be used:
| 'smith' - disconnects user Smith's clients. |
| '@smith' - disconnects all users whose name resembles 'smith'. |
| '%' - disconnects all users including the current dba session. |
Return Values
The number of clients disconnected is returned.
Examples
Example24.95.Disconnect users
This is how the DBA can close all sessions for all users who name starts with db, including 'dba' which is the DBA itself.
SQL> disconnect_user ('db*');
*** Error 08S01: [Virtuoso Driver]CL065: Lost connection to server
at line 7 (7) of Top-Level: disconnect_user ('db*')
bash$