Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 ArcGatalog,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

4.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" "can not edit the folder or database you selected,the user doesn't have enough permission"

Anyone can help me solve this problem?Is this problem because the layer is inside a feature dataset?or member of geometric network?so how I can give update permission fot this layer?

Thanks in advance

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

You can use ArcCatalog and in this case you need to grant the permissions on the feature dataset in which the network resides, not its individual feature classes.

Note that it's not the geometric network (or topology etc.) which dictates this approach, it's the presence of a feature dataset.

share|improve this answer
    
Thank you very much,but when I use privilege menu to grant permission for feature dataset to a user, all feature classes inside feature dataset will be updatable by that user,but I want he/she can update only one feature class in that feature dataset,is there any way to reach this type of permission? –  Reza Dec 26 '10 at 18:07
    
As far as I know, there is not. Once you group feature classes under a feature dataset, that dataset essentialy becomes a single unit on which you set permissions. I have never quite understood why ESRI chose this design, to be honest. I know that you need to have the dataset so that a geometric network can be created, but my advice would be to keep only the network classes in the dataset and put everyhing else somewhere separate, i.e. in the root or another dataset. –  Petr Krebs Dec 26 '10 at 18:16
2  
Having the same set of permissions on all the classes of a geometric network should not be a major limitation. Quite the opposite - I think it's more than recommended to keep permissions of the whole geometric network consistent so that no problems arise during editing. –  Petr Krebs Dec 26 '10 at 18:18
    
Thank you very much petr.I got the answer. –  Reza Dec 27 '10 at 6:11
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.