I want to set up Active Directory authentication for my users, who will be assigned to specific database roles. I also need to log activity and ensure I have captured the IDs of the indivudals connected.
I have found simple instructions on how to do it. ( How do I assign an entire Active Directory group security access in SQL Server 2008? )
... But Will SYSTEM_USER return the logon id of the active directory connection or the individual user? (Unfortunately I cannot test this!)