Disconnect User Permissions?

2871
3
Jump to solution
09-16-2014 08:58 AM
Highlighted
Regular Contributor

I have an ArcGIS for Server 10.2.2 Enterprise Geodatabase in SQL Server 2008 R2. It was set up with Database Permissions in SQL Server, not Windows/OS. I am the Database Administrator.

 

I need to disconnect a user from our Enterprise Geodatabase and when I try to do so it says I do not have the permissions.

 

In ArcCatalog, I went to my Enterprise Geodatabase - Administration - Administer Geodatabase - Connections. I chose the user to disconnect but then a message pops up saying I do not have the permissions to do so.

 

What additional permissions do I need to set in SQL Server Management Studio to be able to disconnect a user from our Enterprise Geodatabase?

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Regular Contributor III

Removing connections from a geodatabase in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

The geodatabase administrator in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

You will have to grant that user the processadmin fixed server role to grant it sufficient permissions to disconnect other connections.

View solution in original post

3 Replies
Highlighted
Regular Contributor III

Removing connections from a geodatabase in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

The geodatabase administrator in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

You will have to grant that user the processadmin fixed server role to grant it sufficient permissions to disconnect other connections.

View solution in original post

Highlighted
Regular Contributor

Thanks, your help was very useful. Problem solved.

Reply
0 Kudos
Highlighted
Regular Contributor III

Great!! Mark the thread as Answered or the reply helpful, if possible.

Reply
0 Kudos