We have an 10.1 SDE setup with SQL Server. It has been setup with Database Authentication Type. All ArcGIS users access the database through this connection. All database feature class locks show up as being in use by this master connection user, (not the actual user who is accessing it). We have some people telling us this is best practice and others saying this is a security concern as everyone has the same permissions and there is no way to see who is accessing what. We need to be able to see sde locks by user, and also need to be able to setup sde groups and user based permissions to feature classes. Can anyone offer advice? Thanks.
... View more