topic Insufficient Permissions when using IFeatureClass.CreateFeature in ArcObjects SDK Questions

Insufficient Permissions when using IFeatureClass.CreateFeature

TravisSparks — Thu, 27 Oct 2011 14:03:11 GMT

I have connected successfully to an sde database using an IFeatureWorkspace, and have an IFeatureClass object for the feature class I want to work with. When connected as a user that is NOT the owner of any feature classes, but that does have SELECT, INSERT, UPDATE, and DELETE permissions (using ISQLPrivilege) on the feature class, I am able to update existing features, but not create new ones.

To update, I use the IFeatureClass.GetFeature method to return an IFeature, I update the appropriate field values, and I call IFeature.Store, which updates the feature in the feature class successfully. However, if I use IFeatureClass.CreateFeature to create a new feature to store in the feature class, I get an 'Insufficient Permissions' error.

I've tried wrapping the operations in an IWorkspaceEdit edit session and edit operation, but that doesn't have any effect in this case. If I connect as the feature class owner, this all works fine, so it would seem that the approach is ok, minus this permission issue.

Any ideas?

Thanks

Re: Insufficient Permissions when using IFeatureClass.CreateFeature

NeilClemmons — Thu, 27 Oct 2011 19:20:27 GMT

What happens when you try creating a new feature in this feature class using ArcMap? If you get a similar error then the problem is probably on the database side rather than in your code.

Re: Insufficient Permissions when using IFeatureClass.CreateFeature

TravisSparks — Fri, 28 Oct 2011 19:55:36 GMT

It turns out I hadn't set the user privileges on the feature class inside ArcCatalog. Is there some way to determine these feature class permissions via code? I've been using the following, where PrimaryCPFeatureClass is a populated feature class:

IDataset dataset = (IDataset)PrimaryCPFeatureClass;
IDatasetName datasetName = (IDatasetName)dataset.FullName;
ISQLPrivilege sqlPriv = (ISQLPrivilege)datasetName;

The sqlPriv object was providing the privileges as they exist on the underlying SQL table, but apparently not the privileges of the sde feature class itself, which is what I need access to.