By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

SQL user and group audit report

P: n/a
I am trying to create a TSQL statement or stored procedure that can
tell me what users belong to what group and what groups have access to
what files. Can anyone help? Can I pull out a list of names from
Active Directory to use as my user list?

Apr 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
There is an example in books on line on querying a linked server to active
directory, have a look at it. If you've got any questions , reply to the
post

--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm

<yz*****@yahoo.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...
I am trying to create a TSQL statement or stored procedure that can
tell me what users belong to what group and what groups have access to
what files. Can anyone help? Can I pull out a list of names from
Active Directory to use as my user list?

Apr 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.