Using Application Role permissions between ArcMap and SQL Server

247
2
12-18-2013 06:21 AM
847396730
Occasional Contributor III
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!
0 Kudos
2 Replies
LeoDonahue
Regular Contributor
What permissions do all of these database user logins have (that are new hires and departures)?  What are you allowing them to do?
0 Kudos
847396730
Occasional Contributor III
They are participating in the versioned editing of their workgroup/division's data.
0 Kudos