topic I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated &quot;insufficient permission&quot;. How can I fix it? I need to disconnect users. I also have access to SQL Server Management Studio in Data Management Questions https://community.esri.com/t5/data-management-questions/i-am-a-data-owner-when-i-clicked-administrator/m-p/229575#M12995 <HTML><HEAD></HEAD><BODY><P>I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated "insufficient permission". How can I fix it? I need to disconnect users. I also have access to SQL Server Management Studio.</P></BODY></HTML> Sun, 02 Jul 2017 21:46:55 GMT AlexP_ 2017-07-02T21:46:55Z I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated "insufficient permission". How can I fix it? I need to disconnect users. I also have access to SQL Server Management Studio https://community.esri.com/t5/data-management-questions/i-am-a-data-owner-when-i-clicked-administrator/m-p/229575#M12995 <HTML><HEAD></HEAD><BODY><P>I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated "insufficient permission". How can I fix it? I need to disconnect users. I also have access to SQL Server Management Studio.</P></BODY></HTML> Sun, 02 Jul 2017 21:46:55 GMT https://community.esri.com/t5/data-management-questions/i-am-a-data-owner-when-i-clicked-administrator/m-p/229575#M12995 AlexP_ 2017-07-02T21:46:55Z Re: I am a data owner. When I clicked administrator geodatabase on data connection and tried to disconnect user locks however it stated "insufficient permission". How can I fix it? I need to disconnect users. I also have access to SQL Server Management St https://community.esri.com/t5/data-management-questions/i-am-a-data-owner-when-i-clicked-administrator/m-p/229576#M12996 <HTML><HEAD></HEAD><BODY><P>Being the Data Owner is not enough to disconnect users from a geodatabase. Check this link for more details:</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/manage-connections-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/manage-connections-sqlserver.htm">Manage connections in SQL Server—Help | ArcGIS Desktop</A>&nbsp;</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P style="color: #4d4d4d; background-color: #fefefe; font-size: 0.875rem; margin-top: 0em; margin-bottom: 1.71429em;">To disconnect users from a geodatabase in Microsoft SQL Server, the geodatabase administrator may need additional privileges.</P><UL class="" style="color: #4d4d4d; background-color: #fefefe; font-size: 0.875em; margin-bottom: 1.5em;"><LI style="font-size: 0.875rem; padding-left: 1em;">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.</LI><LI style="font-size: 0.875rem; padding-left: 1em;">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.</LI></UL><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">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.</SPAN></P></BLOCKQUOTE></BODY></HTML> Mon, 03 Jul 2017 10:57:17 GMT https://community.esri.com/t5/data-management-questions/i-am-a-data-owner-when-i-clicked-administrator/m-p/229576#M12996 Asrujit_SenGupta 2017-07-03T10:57:17Z