title: How to show a list of sites the current user can access?
body: <p>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:</p>
  
  <ol>
  <li>Use FullTextSqlQuery class to search for the sites, but is it possible;</li>
  <li>Build an external application that crawls the user-sites information by using the Sharepoint Object-Model. The webpart can then use this information.</li>
  </ol>
  
  <p>Is there any simple solution?</p>
  
  <p>Any idea will be appreciated. Thanks!</p>