Using Application Role permissions between ArcMap and SQL Server

Discussion created by MLF on Dec 18, 2013
Latest reply on Dec 20, 2013 by MLF
We have been using Database Roles and creating database user logins (Windows auth) for every individual who accesses our SQL Server ArcSDE geodatabase.  Though not terribly cumbersome, there is a delay with new hires and departures.  Can anyone speak to the efficacy of using Application Roles instead, whereby ArcMap itself authenticates, and all permissions are handled by SDE?
Thank you!