topic ArcSDE tool for ArcCatalog Version 10 in Data Management Questions

ArcSDE tool for ArcCatalog Version 10

MartinSiwek — Tue, 01 Mar 2011 15:16:07 GMT

In ArcGIS 9.3.1 there was an ArcSDE tool that you could add into ArcCatalog to administer feature class permissions. After it was installed it would appear as a tab in ArcCatalog next to the Preview tab. Is there a version of this available for ArcGIS Desktop 10?

Thanks

Re: ArcSDE tool for ArcCatalog Version 10

BrettHill — Tue, 01 Mar 2011 23:31:39 GMT

I believe you're looking for the Geodatabase Toolset, version 10 is available.

http://www.esri.com/software/arcgis/extensions/gdbt/index.html

Re: ArcSDE tool for ArcCatalog Version 10

RudyProsser — Thu, 03 Mar 2011 21:59:41 GMT

I think you're referring to the ArcSDE Privileges Report. It added a tab to ArcCatalog that allowed you to see who had Viewer/Editor privileges over the entire geodatabase or on individual data objects. Unfortunately, it hasn't been updated for ArcGIS 10 as of this date.

At ArcSDE 10 you can use the sdetable -o list_grantees command to list permissions for each user granted access to the table. For example

sdetable -o list_grantees -t dbo.parcels

User Name: GISEditors
Privileges: SELECT, INSERT, UPDATE, DELETE

User Name: GISViewers
Privileges: SELECT

Re: ArcSDE tool for ArcCatalog Version 10

JohnMeza — Wed, 16 Mar 2011 14:28:51 GMT

GDBT hasn't provided functionality to administer feature class user privs. Not a bad idea. I would use the info provided by the previous post.

Re: ArcSDE tool for ArcCatalog Version 10

ClaraDair — Mon, 28 Nov 2011 17:11:23 GMT

I think you're referring to the ArcSDE Privileges Report. It added a tab to ArcCatalog that allowed you to see who had Viewer/Editor privileges over the entire geodatabase or on individual data objects. Unfortunately, it hasn't been updated for ArcGIS 10 as of this date.

At ArcSDE 10 you can use the sdetable -o list_grantees command to list permissions for each user granted access to the table. For example

sdetable -o list_grantees -t dbo.parcels

User Name: GISEditors
Privileges: SELECT, INSERT, UPDATE, DELETE

User Name: GISViewers
Privileges: SELECT

I'm also interesting in knowing if/when the SDE privileges tool is updated for ArcCatalog 10. In our particular case, we no longer have access to commandline at our nation-wide datacenter to run the command above.

Any suggestions for those of us who already no longer have commandline and will no longer the ArcSDE privs tab in ArcCatalog as we migrate to 10?

Any ideas appreciated! If such a functionality did get incorporated into the GDBT, that would be great, but don't drop the versioning lineage, please!

Thanks, Clara

Re: ArcSDE tool for ArcCatalog Version 10

HarrietMcQuade — Thu, 09 Feb 2012 13:01:05 GMT

Just to add to this post. Our authority would really like to see this for version 10 too!!!
Any sort of tool that will allow you to view priviliges of the feature classes would be so helpful!!!!

Re: ArcSDE tool for ArcCatalog Version 10

MichelleBoivin — Fri, 23 Mar 2012 19:57:53 GMT

I am also very interested in an update on this tool as well. As a City entity running an Enterprise database, we have over 600 objects in SDE. The notes on the previous versions mentioned:

"The ArcSDE Privileges View provides a report of user privileges on a selected
Geodatabase object (Table, Feature Class, Feature Dataset, Raster, Raster Catalog)
or on all objects within a selected Spatial Database Connection."

Since we have so many feature classes, I was hoping to get the "selected Spatial Database Connection" option, which sdetable -o list_grantees does not provide.

~Michelle

Re: ArcSDE tool for ArcCatalog Version 10

danan — Sat, 24 Mar 2012 08:21:22 GMT

A great way to influence Esri's Product Roadmap is to create new feature requests, or vote for existing ones, on Esri's SalesForce.com-powered Ideas web site (http://ideas.arcgis.com):

Example:
Give me a GUI for ArcSDE
http://ideas.arcgis.com/ideaView?id=0873000000086rp

I'm personally looking forward to seeing the GDB management capabilities in 10.1 Final having been a "fan" of GDBT over the years.

Re: ArcSDE tool for ArcCatalog Version 10

ToddAGrissom — Tue, 07 Oct 2014 16:41:18 GMT

Work by John Karagiannis is what you are looking for, although I don't think he has updated any of the ArcSDE tabs since 9.3.

Here is the latest link I could find - ArcSDE User Privileges Report (9.3 SP1) , but much of this functionality has been added to the privileges routine in catalog at 10