We have a SPS Portal and a good number of WSS Sites. We have about 450
AD-Users accessing this SPS Portal and corresponding WSS Sites.
I was being asked to create a quick view of all User-Access-Rights on
individual WSS sites. I need to group this by User and by Site.
Something like this
QuickAccessView (
ADUserID,
WSS_Site_Name,
WSS_Site_Group,
Access_Rights
)
It consumes a lot of time if I can navigate to individual site and
every user. Is there any SQL Query or URL or documentation than can
help me to achieve this.