DisconnectUser (arcpy)

Summary

Allows an administrator to disconnect users who are currently connected to an Enterprise geodatabase.

Discussion

The DisconnectUser function is used by an administrative user to disconnect users from an Enterprise geodatabase. This function is used to complement the Connected users dialog box found in ArcGIS for Desktop.

Syntax

DisconnectUser (sde_workspace, {users})
ParameterExplanationData Type
sde_workspace

The Enterprise geodatabase containing the users to be disconnected.

The connection properties specified in the Enterprise Geodatabase must have administrative rights that allow the user to disconnect other connections.

String
users
[users,...]

Specifies which users will be disconnected from the geodatabase.

  • sde_idThe ID value returned from the ListUsers function or the Connections tab in the Geodatabase Administration dialog. This can be passed to the function as an individual sde_id or a Python list containing multiple sde_ids.
  • ALLKeyword specifying that all connected users should be disconnected.
NoteNote:

DisconnectUser will not disconnect the user who is executing the function.

Integer

Code Sample

DisconnectUser example 1

The following example demonstrates how to disconnect all users from a geodatabase.

import arcpy

arcpy.DisconnectUser("Database Connections/admin@sde.sde", "ALL")
DisconnectUser example 2

The following example demonstrates how to run the command to disconnect a single user. In this example, the SDE ID is extracted based on the name of the user that the admin would like to disconnect from the list returned from the ListUsers function

import arcpy

admin_workspace = "Database Connections/tenone@sde.sde"
arcpy.env.workspace = admin_workspace
user_name = "GDB"

# Look through the users in the connected user list and get the SDE ID.
# Use the SDE ID to disconnect the user that matches the username variable
users = arcpy.ListUsers() # The environment is set, no workspace is needed.
for item in users:
    if item.Name == user_name:
        arcpy.DisconnectUser(admin_workspace, item.ID)
DisconnectUser example 3

The following example demonstrates how to run the DisconnectUser command to disconnect multiple users.

import arcpy

# Set the admistrative workspace connection
admin_workspace = "Database Connections/tenone@sde.sde"

# Create a list of users to disconnect.
user_names = ["TRAVIS", "DEBBIE", "PHIL"]

# Get a list of connected users
connected_users = arcpy.ListUsers(admin_workspace)

# Loop through the list of connected users and execute DisconnectUser
# if the user name is in the userNamesList created earlier:
for user in connected_users:
    if user.Name in user_names:
        print('Disconnecting {0}'.format(user.Name))
        arcpy.DisconnectUser(admin_workspace, user.ID)

Related Topics

3/3/2014