[Sharepoint] How to show a list of sites the current user can access?

Question

Hello, I'm working on MOSS 2007 and I want to build a sharepoint webpart that can list all the sites (in the same SPfarm) visible to the current user. What I can think of is:

1. Use FullTextSqlQuery class to search for the sites, but is it possible;
2. Build an external application that crawls the user-sites information by using the Sharepoint Object-Model. The webpart can then use this information.

Is there any simple solution?

Any idea will be appreciated. Thanks!

Answer 1

Please take a look here: Talk to SharePoint Through its Web Services at "Example 3"

You'll need to write some managed (.net) code.

Answer 2

SharePoint creates site maps by default. Unless you have turned this off, you can get one from a site by appending /_layouts/viewlsts.aspx to the site URL.