topic Is there a way to list database users? in ArcGIS Enterprise Questions

Is there a way to list database users?

PaulHuffman — Fri, 26 Feb 2016 21:24:56 GMT

I'm using Arc 10.3.1, SQL Server 2012, Windows Server 2012. Is there a way using ArcCatalog administrative tools to list the database users and privileges that have been added, not just the active connections?

Re: Is there a way to list database users?

SamuelTompsett — Sat, 27 Feb 2016 00:09:15 GMT

Hi Paul,

Are you looking for object level privileges from Feature Classes and Feature Datasets? If so, you can access the privilege dialog through right click > manage > privileges. This will list all the database users that have Select, Insert, Update and Delete on that object.

However, for database level permissions, like CREATE TABLE, that wouldn't be accessible from ArcCatalog out of the box. The only thing you could do is create a database view from ArcCatalog or RDBMS side that would show you that information. My other question for you is what do you plan on doing with the database permissions from ArcCatalog, just view them?

Hopefully that helps.

-Sam

Re: Is there a way to list database users?

PaulHuffman — Sat, 27 Feb 2016 00:38:25 GMT

right click > manage > privileges only seems to work for me for items within a database, not for the whole database. When I right click on a database, I get Administration, not manage.

I need to be able to grant one of my users the ability to create new feature classes in this data base. For feature datasets, I was able to grant him Select, Insert, Update, and Delete, but it doesn't seen to be enough.

Re: Is there a way to list database users?

SamuelTompsett — Mon, 29 Feb 2016 15:02:35 GMT

Hi Paul,

The behavior you are seeing is expected. The privileges dialog in ArcCatalog/ArcMap is for granting users privileges to edit the feature class/table. You cant grant database level permissions from ArcGIS for Desktop. You only have access to object level privileges.

In order for a user to create new feature classes you would have to grant the following:

Create Table

Create Procedure

Create View

That can be done in SQL Server Management Studio. Right click the database > Properties > Permissions.

Privileges for geodatabases in SQL Server—Help | ArcGIS for Desktop

Hopefully that helps.

Sam