SQL Server Group Trace | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Group Trace

My problem is as follows. I have user thats is a member of to AD groups A, B, C and D. These groups A, B, C, D are members in group AA, BB etc. And the the group AA, BB are Windows group Windows Group Logins in the SQL 2005 sp4 server. I’m using SQL Server Profiler and make a trace for Audit. The trace gives med Login that are in use. But is possible to trace what AA, BB, CC group that grants him permission to the server without lookin throw the hole AD and different groups he is member of.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |