December 15, 2009 at 12:25 pm
In my environment, we use Windows domain groups to grant access to users. I can use SYSTEM_USER to get the actual person's login, but I can't seem to find a way to determine what domain group they are receiving permissions through. I'm using SQL 2005 currently, but will be migrating shortly to 2008. If someone knows of how to do this in either platform, I would GREATLY appreciate it.
My goal is to use this to troubleshoot permissions issues and do some group auditing.
Thanks,
Jason
December 15, 2009 at 1:02 pm
Jason,
Not really sure if this is what your looking for
http://www.mssqltips.com/tip.asp?tip=1252
Nice script to list out each user within a Window group and permissions.
December 15, 2009 at 1:07 pm
Lookup xp_logininfo in BOL (Books Online).
December 17, 2009 at 6:32 am
BIG THANKS!!! That is exactly what I needed. Can't believe xp_logininfo never showed up in any of the google searches I did. Maybe I should have used Bing. 😀 Thanks again.
December 17, 2009 at 6:38 am
Glad I could help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply