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; } } }

Missing permissions for removing and disconnecting locks/users from an SDE connection.

Yogesh_Chavan

We have SQL Server 2022 and in ArcGIS Pro 3.3 when we try to disconnect a user from the connection, it fails with the below error:

Through some research we got to know that DB owner should have View_Definition permission which we granted. Issue is still observed.

What else are we missing here?

Find more posts tagged with

Enterprise geodatabase

Databases

Geodatabase Administration

Accepted answers

JakeSkinner

Hi @Yogesh_Chavan, is your geodatabase administrator a user named sde or a login that is mapped to the dbo user in the database that contains the geodatabase? The user must also be added to the processadmin server role to disconnect users.

All comments

JakeSkinner

MMBR

@Yogesh_Chavan

Privileges for geodatabases in SQL Server

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm#:~:text=by%20ArcGIS.-,Minimum%20privileges,-Type%20of%20user

For best practices on how to setup a production enterprise geodatabase in SQL Server read my database guide books and database template scripts for Production Mapping in my community.esri.com blog.
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

Yogesh_Chavan

Thank you @JakeSkinner !!

Yogesh_Chavan

Thank you @MarceloMarques .

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.