... I�??m wondering now if there is a way to show all the users �??attached�?� to particular connection.
Hi Jamal,
FYI, in ArcGIS for Desktop 10.1 there is a new Geodatabase Administration dialog box that provides geodatabase administrators with the ability to monitor and manage user connections, locks, and versions.
What's new for geodatabases in ArcGIS 10.1
(look under the New ArcGIS tools to administer enterprise geodatabases section)
Hope this helps,
Hi Jamal,
At 8.x and 9.x, there used to be a great but simple tool that did just that (and a lot more). It was called "Geodatabase Reporter" and created an overview of all relevant settings in a geodatabase, like which Feature Datasets, Feature Classes, Topologies, versions etc. there were, including detailed information on field names and types. It also included access rights / privileges on datasets if I remember it well.
It simply created an HTML page output showing all relevant data that could be printed for future reference.
Now with 10.x, I can't easily find it anymore... maybe someone else knows if you can still get a working version of it. However, I do know there are two other unsupported but powerful geodatabase tools that may be of help to you:
X-Ray for ArcCatalog (ArcGIS 10)
ArcGIS Diagrammer for 10.1
See the pages for what they do, and more useful, download them and see if they are of help. Also, there is a video of X-Ray:
Introduction to X-Ray for ArcCatalog
There have been multiple pleas by different people to integrate much of these type of tools in core ArcGIS, and 10.1 indeed does include some of this functionality, but there still are things missing.
One other remark concerning your issue:
It is best practice to use assign geodatabase Feature Class privileges to database "Roles" instead of to individual database "Users". I strongly advice you to do so, as it greatly simplifies privilege maintenance. If you assign your database users to individual groups that need specific privilege rights on certain Feature Classes, and than create a Role for that group of users and add all database users to that group using your database management system (e.g. SQL Server), you subsequently only need to assign all the needed geodatabase privileges to the single Role instead of potentially dozens or hundreds of users.
And if you wanted to know which users have what rights on a Feature Class, you simply first look at what "Roles" have what rights, and than use the database management console to look up which "Users" belong to that specific "Role".
Generally, you would also distinguish Roles not only based on which Feature Classes these users need to see / be able to use, but also based on whether or not they need to edit data.
So you might have a Role "Ramallah Editor" and "Ramallah Viewer", or a more specific Role "Ramallah Utilities Editor" and "Ramallah Utilities Viewer".