Question:

I’m looking for some code to or at least an example of how to navigate through all the sites in a sharepoint installation to extract user, roles and group (any other level permissions Ithat will be present) permissions for all sites (full SQL Server 2005 installation).  Any help is appreciated.  Is it best to go through SQL Server? or .NET?  Which tables is the information stored?

Thanks

Solution:

in my opinion, the easiest way is via SQL.

this SQL query should get you started:

https://blogs.technet.com/wbaer/archive/2006/12/09/simple-query-to-audit-site-collection-web-access-levels.aspx

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/d2b1e713-5bfc-43f2-a573-25ce1a37015e/