Granting editing privileges is negating the AOI restrictions

Discussion created by rarbuthnot on Jan 26, 2012
Latest reply on Mar 5, 2012 by tbello-esristaff
I am trying to setup a production system using ArcSDE and Workflow Manager.  We want to use the AOI editing restriction to keep people from editing data outside of their assigned AOIs.  In order for people to modify and create feature geometry though I have to give them CREATE, DELETE, INSERT, and UPDATE privileges from the dbo user.  When I do this, the AOI restrictions are no longer having any affect.  How can I remedy this?  It seems like it shouldn't be working this way.

Technical stuff

ArcGIS 10 SP3
WMX 10 SP3
ArcSDE 10 SP3
SQL Server 2008 R2