Select to view content in your preferred language

Workgroup SDE: user permissions changed after data register as versioned

893
1
10-16-2012 08:26 AM
xiannianchen
Deactivated User
Configurations: ArcSDE Workgroup on SQL Server Express (10.1).

Basically, we just want this user not to delete, not to update the existing features but to create new features.

The followings are done through DATABASE CONNECTION in ArcCatalog's Catalog tree.

Before the dataset is register, user permissions on that dataset have only one: INSERT. After the dataset is registered as versioned, the same user's permissions are changed. All of the three write permissions, e.g., INSERT, UPDATE, and DELETE, are selected.

There is no way to just select one permission. For example, if INSERT is checked, the other two editing permission, UPDATE and DELETE, are selected automatically; if INSERT is un-checked, the other two editing permission, UPDATE and DELETE, are de-selected automatically. It sounds like that the editing permissions are packed in one permission, e.g. write.


On the other hand, from DATABASE SERVER in ArcCatalog's Catalog tree, through a database server connection, there are read and write permission. The WRITE permission is NOT detailed as update, insert, and delete.

In the ArcSDE Enterprise level, these permission can be set separately.
What is going on here? Does it mean that permission setting in ArcSDE Workgroup can NOT be as specific as UPDATE, INSERT, and DELETE, but be general as WRITE? Is this the setting of Workgroup ArcSDE?

Any other helps will be more than welcome.

Thanks,

Mike
0 Kudos
1 Reply
AsrujitSengupta
Deactivated User
If the dataset is registered as versioned, the Insert, Update and Delete privileges must be granted or revoked as a group.

The following webhelp mentions the same (at the bottom of the page):

What are user privileges?
http://resources.arcgis.com/en/help/main/10.1/index.html#//002q0000002r000000

Regards,
Asrujit
0 Kudos