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

Example 24.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$


See Also:

username