Summary
Allows an administrator to enable or disable the ability of nonadministrative users to make connections to an enterprise geodatabase.
Discussion
The AcceptConnections function is used by an administrative user to temporarily block connections to an Enterprise geodatabase. This function is used to complement the Connections tab on an Enterprise geodatabase properties page found in ArcGIS Desktop.
- The AcceptConnections function must utilize an administrative connection to the database.
- If this function is attempted to be run by a nonadministrative user the function will fail.
Syntax
AcceptConnections (sde_workspace, accept_connections)
| Parameter | Explanation | Data Type |
sde_workspace | The Enterprise geodatabase that will have its connection property altered. The connection properties specified in the Enterprise Geodatabase must be the geodatabase administrator. | String |
accept_connections | Boolean value indicating if the geodatabase will accept connections (True) or will not accept connections (False). | Boolean |
Code sample
The following example demonstrates how to prevent connections to a geodatabase.
import arcpy
arcpy.AcceptConnections("Database Connections/admin.sde", False)The following example demonstrates how to prevent connections to a geodatabase, disconnect active connections, then run a geodatabase compress.
import arcpy
# Set Admin workspace variable
admin_workspace = "Database Connections/admin.sde"
# Block connections
arcpy.AcceptConnections(admin_workspace, False)
# Disconnect users
arcpy.DisconnectUser(admin_workspace, 'ALL')
# Reconcile/Post using default parameters.
arcpy.ReconcileVersions_management(admin_workspace, 'ALL_VERSIONS',
'sde.DEFAULT', with_post='POST')
# Compress the geodatabase
arcpy.Compress_management(admin_workspace)
# Allow connections.
arcpy.AcceptConnections(admin_workspace, True)