Geodatabase Object Ownership Management for ArcSDE Databases

Idea created by bljackson on Jul 19, 2011
    • imfeld
    • bljackson
    • Gerald
    • CFMENG
    • gargi
    • BrianO
    • jdegraff
    • Sappi
    The new management features for enterprise geodatabases in ArcCatalog 10.1 are great, but there is an additional one I would like to see:  ArcSDE geodatabase object ownership management.

    Currently, if a user has create permissions, data within the database is owned by that user.  If that user leaves the organization, ownership needs to be transferred to some other user and that is difficult, even using the database management tools (SQL Server Management Studio in my case).  There are too many objects in the database that ownership would have to be changed on, plus changes in the ArcSDE system tables.  Right now, the best, if clumsy, way to change ownership is to move that data out of the database and then bring it back in using a new user.