Granting permission in ArcSDE geodatabasewhen layers are inside geometric network?

[المشرف العام]

When I use sdetable command to grant pemission to a table that located in a SDE SQL server geodatabase it works properly, this table is a non-spatial table which is in geodatabase immediately, I mean when I open geodatabase in ArcCatalog, I can see it in the root of geodatabase.

But we have a FeatureDataset named "dsDisNet" and almost all feature classes inside in this feature dataset are members of a geometric network(except one).When I use sdelayer command to grant permission for one feature class, it is done successfully but the user can't still update the table.

Here is steps I do:

1. define a login in SQL Server, then define a user in geodatabase mapped to login
2. give the data_reader role to this user, so user can see all layers successfully
3. run this command
   
   sdetable -o grant -t myTable -U gisUser1 -A SELECT,INSERT,UPDATE,DELETE -s GISServer -i 5151 -D GDBase -u sa -p mypassword
   

and it works successfully, and this user can work with that table

1. sdelayer -o grant -l myLayer,Shape -U gisUser1 -A SELECT,UPDATE -s GISServer -i 5151 -D GDBase -u sa -p mypassword

this last command doesn't work properly even it is run successfully,but the user still receive this message in ArcMap (something like this "cannot edit the folder or database you selected, the user doesn't have enough permission"

Is this problem because the layer is inside a feature dataset or member of geometric network? If so, how I can give update permission for this layer?



أكثر...