+ Reply to Thread
Results 1 to 8 of 8

Thread: ArcSDE tool for ArcCatalog Version 10

  1. #1
    Martin Siwek
    Join Date
    Apr 2010
    Posts
    41
    Points
    1
    Answers Provided
    0


    1

    Question ArcSDE tool for ArcCatalog Version 10

    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

  2. #2
    Brett Hill
    Join Date
    Dec 2010
    Posts
    18
    Points
    5
    Answers Provided
    1


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

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

    http://www.esri.com/software/arcgis/...dbt/index.html

  3. #3
    Rudy Prosser
    Join Date
    Jan 2010
    Posts
    1
    Points
    0
    Answers Provided
    0


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    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

  4. #4
    John M
    Join Date
    Feb 2010
    Posts
    15
    Points
    6
    Answers Provided
    1


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    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.
    johnm

  5. #5
    Clara Dair
    Join Date
    May 2010
    Posts
    8
    Points
    0
    Answers Provided
    0


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    Quote Originally Posted by rprosser View Post
    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

  6. #6
    Harriet McQuade
    Join Date
    Aug 2011
    Posts
    29
    Points
    0
    Answers Provided
    0


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    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!!!!

  7. #7
    Michelle Boivin
    Join Date
    Apr 2010
    Posts
    33
    Points
    5
    Answers Provided
    1


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    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

  8. #8
    dana n
    Join Date
    Apr 2010
    Posts
    253
    Points
    7
    Answers Provided
    0


    0

    Default Re: ArcSDE tool for ArcCatalog Version 10

    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.
    Dana

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts