Hello everyone,
I'm experiencing an unusual issue with an Enterprise Geodatabase hosted on SQL Server. Specifically, I'm unable to delete a feature class within a dataset from ArcGIS Pro. When I attempt to delete the feature class, the process appears to complete successfully without any errors. However, after refreshing the feature dataset, the feature class still appears intact. Furthermore, I can add it back to the map without encountering any issues, and the data remains unaffected.
Some other information
Environment information
Has anyone else encountered this problem or have any suggestions on how to resolve it?
Thank you!
Solved! Go to Solution.
Does the user you used follow this pattern "domain\username"?
Yes it does.
Is the behavior reproduced with another OS account that can be tested by a colleague?
Is the .....\GISAdmin OS account an individual account for one user? Or does it act like a group?
Yes, the behavior can be reproduced with another OS account. I have tested another account of my colleague and the issue appeared again.
The GISAdmin is an individual account not a group. Also the account I have just tested is an individual account.
The scenario I follow is
1.Create OS login (search for login in active directory)
2.Map the login to a certain database
3. Create a schema with the same name the user that is created in the database after mapping.
4. Assign the schema to the user
5. Grant the permission from SQL Server (Table, view, procedure)
6.Connect from ArcGIS Pro and start creating data (Feature dataset, and feature class)
7. Try to delete a feature class
Hi @gisarchitect ,
Looking at the earlier post and recent one, are you assigning Create Function?
If we were to go and check the explicit permission on the user (Right Click DB --> properties --> select permissions page --> select user account)
My explicit permissions are the following:
Marlon
I have checked my explicit permissions and they were as the documentation as follows
However, I have added the remaining as you described above which are (View Definition, Create Function) and there is no effect after I added them.