I have two C# apps with Windows Auth to Microsoft SQL Server 2008 R2.
For every app:
- SQL login based on Windows Group is created
- SQL server login is mapped to SQL database user
- user is member of a role
- role has granted permissions to tables, views, procedures, etc.
If I add a single windows user as a member to both windows groups (with are "mapped" to different SQL logins, which are mapped to different SQL users, which belongs to different roles and so on..) - could user run both apps without any problems or only one of them will work properly?