nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automate Locks Management

CraigCarsley

Does anyone know of any way to automatically break user connections to an enterprise geodatabase?
We are trying to run some scripts overnight, but they need to acquire locks on certain datasets, and we have some users who leave connections open.

I'd like to find a way to break their connections without having to go through the manual process.

Thanks!

Find more posts tagged with

Accepted answers

VinceAngelo

Database connection termination is a database feature. The syntax varies by RDBMS.

The only way Esri code could be involved is if an application server connection is used
(and doing so is discouraged, partially because of this vulnerability).

I expect you could script user session termination in any of the dozen ArcSDE-supported
RDBMSes.

- V

All comments

Bud

This post is quite old. I wonder if anything has changed since then? Any enhancements added to ArcGIS, etc.?

ForrestJones

Also...to add to Russell's info about the GP tools (which you can script), you can list and disconnect users through the ArcGIS gui. This is from the 10.1 help (similar for 10.2):

Viewing connected users in ArcGIS for Desktop

The above has links to topics for removing connections from different types of databases. You'll have to make sure the sde admin user has the correct privileges (this is discussed in the help topics).

RussellBrennan

The functions you are looking for are arcpy.ListUsers and arcpy.DisconnectUser

List Connected Users
http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000030000000

Disconnect users:
http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000061000000

The third example for disconnect users shows how to use the list users function with the disconnect users function to disconnect only specific users based on their names.

This will work for both application server connections (3-tier) as well as direct connections (2-tier).

Russell

VinceAngelo

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.