SQL Server Performance

SQL Server Group Trace

Discussion in 'ALL SQL SERVER QUESTIONS' started by jn4u, Feb 22, 2012.

  1. jn4u Member

    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.

Share This Page