topic Re: Disconnect user using arcpy Error in Data Management Questions

Disconnect user using arcpy Error

VikramS — Mon, 03 Mar 2014 15:38:50 GMT

Hello All,

I have .sde file with database connection credentials . The credential has dbo_owner access . But When I try to run arcpy.DisconnectUser ,ut gives me an error saying that I am not using administrative connections . Do I need to have administrative connections to the GDB or to the entire sql instance ?

Connection information provided was for a non-administrative user

Please advise

Re: Disconnect user using arcpy Error

VinceAngelo — Mon, 03 Mar 2014 16:44:16 GMT

The user must have the database privilege necessary to disconnect other users.
DBO is not enough -- For SQL-Server, "ALTER ANY SESSION" is required.

- V

Re: Disconnect user using arcpy Error

AsrujitSengupta — Mon, 03 Mar 2014 20:18:58 GMT

Vikram,

To disconnect users, the geodatabase administrator may need additional privileges.

The geodatabase administrator (sde) in an sde-schema geodatabase requires VIEW DEFINITION privileges on the database to see the list of connected users, and must be a member of the processadmin fixed server role to disconnect users.

If the geodatabase administrator of a dbo-schema geodatabase is the database owner, the geodatabase administrator must be added to the processadmin fixed server role to disconnect users.

No additional privileges are required for the geodatabase administrator in a dbo-schema geodatabase if the geodatabase administrator is a member of the sysadmin fixed server role.

Removing connections from a geodatabase in SQL Server:
http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000r8000000

Re: Disconnect user using arcpy Error

AsrujitSengupta — Mon, 03 Mar 2014 20:24:48 GMT

simply stated the "process_admin" server role along with db_owner should be sufficient!

Re: Disconnect user using arcpy Error

Anonymous User — Thu, 23 Apr 2015 03:01:24 GMT

May I suggest the responses posted here be added to the Help document to clarify the privileges required as indicated in the Help? ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Disconnect user using arcpy Error

TaraDeRosa — Thu, 02 Nov 2017 15:36:42 GMT

We are attempting to use arcpy.DisconnectUser before running a nightly compression of a geodatabase. But when running arcpy.DisconnectUser, we are intermittently receiving an error stating that the connection information provided was for a non-administrative user. The geodatabase uses dbo-schema and we have confirmed that the geodatabase administrator is a member of the sysadmin server role.

Our SDE maintenance scripts fail periodically due to this issue similar to this post: https://community.esri.com/thread/180900. SDE is running v10.3.1 with a SQL Server 2012 back-end. The script runs from a VM that has ArcGIS 10.4.1 installed.