Problem:
I am a Computer Analyst on a town hall. Here we have the sector A and B. Both work in ArcGIS 10 Desktop. The sector A has granted to access/edit everything. The sector A has all the privileges! The sector B can see everything. But, the sector B can only edit some Layers/Dataset.
I'm having problems with the Oracle user B sector in SDE.
What I tried:
I tried to grant privileges in Oracle. To the user of sector B I grant to access/edit all. I only blocked the sector B some tables (layers). That he can't change. The user of the sector B can access the ArcGIS Desktop and can see all Layers. But, the user of sector B get an error when, by the ArcGIS Desktop, he try to edit a Layer that he has privileges. I can't understand, because I grant all the tables, including the temp tables of ArcGIS, just don't grant some tables (of some layers). The error occurs when giving a "Start editing" a layer that user B has full permission.
That is the description of the error:
"
Error: No editable layers
ArcGIS 10
None of the layers in your map can be edited. You cannot start an edit session on this data.
Solution: Make sure that the data you want to edit is in a format that can be edited in ArcGIS and that you have the proper permissions to edit it.
More information: In ArcGIS, you can edit data from shapefiles; geodatabase feature classes; standalone table formats, such as INFO or .dbf; and the attribute tables of certain rasters. If your map has data in any other format, you are unable to edit it. Make sure that the data you are attempting to edit is in one of these supported formats. If the data is not from any of these workspaces, it may be possible to export it to one of these formats to be able to edit it.
Many times, you encounter this error along with layer warnings that may provide more specific reasons why the layer cannot be edited. For example, if you have data from a geodatabase in the map but the feature classes are read-only, you also receive a warning message telling you that you need to check the permissions.
"
Question:
Anyone have any suggestions? How do you control your users in ArcGIS 10 Desktop?
What I did wrong? Can I manage in ArcGIS Server Manager users of ArcGIS Desktop?
The idea is simple, the user sector B in ArcGIS Desktop can not access some layers. But I do not know do it.
Best Answer
We generally use the Change Privilege geoprocessing tool from the Toolbox, to give editing/viewing rights over a particular dataset.
Since there are so many supporting tables that are used while editing, I would suggest that you use this GP tool to set the required privilege.