Richard Willis – SharePoint Learning Kit Coordinator, SalamanderSoft Owner

SELECT DISTINCT ra.RoleId FROM RoleAssignment AS ra
WHERE ra.ScopeId = '67FD4879-2097-4B98-9771-5A6E9D11F0E9' AND ra.PrincipalId IN (3,1 )

SELECT DISTINCT ra.RoleId FROM RoleAssignment AS ra
WHERE ra.ScopeId = '67FD4879-2097-4B98-9771-5A6E9D11F0E9' AND ra.PrincipalId
IN (SELECT DISTINCT ra.RoleId FROM RoleAssignment AS ra WHERE ra.ScopeId = '67FD4879-2097-4B98-9771-5A6E9D11F0E9' AND ra.PrincipalId IN (839,1840,1841,.......,2611,2612,1 ) 

using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;
using Microsoft.SharePoint; 

namespace SharePointTest
{
  public class AllRolesTest
  {
    public static void Main()
    {
      //Url to a SharePoint site. Any site but don't do it on a live server. 
      string url = "http://salamanderdemo/sites/mis";
      //The username of the user you are running as. I could have programmatically found this out, but it
      //wouldn't have added anything to the example 
      string userName = "DEMO\\Administrator"; 

      try
      {
        using (SPSite site = new SPSite(url))
        {
          using (SPWeb web = site.OpenWeb())
          {
            SPUser user = web.SiteUsers[userName]; 

            // This call should succeed 
            SPRoleDefinitionBindingCollection allRoles = web.AllRolesForCurrentUser;
            Console.WriteLine("First AllRolesForCurrentUser worked."); 

            List<string> names = new List<string>();
            try
            {
              //Create all the groups 
              for (int i = 0; i < 800; i++)
              {
                if (i%100 == 0)
                {
                  Console.WriteLine("Added {0} groups.", i);
                }
                string name = Guid.NewGuid().ToString();
                names.Add(name);
                web.SiteGroups.Add(name, user, user, name);
              } 

              try
              {
                // This call should fail 
                allRoles = web.AllRolesForCurrentUser;
                Console.WriteLine("AllRolesForCurrentUser succeeded, try adding more groups.");
              }
              catch (SPException e)
              {
                Console.WriteLine("AllRolesForCurrentUser failed.");
                Console.WriteLine(e.Message);
              }
            }
            finally
            {
              int i=0;
              foreach (string name in names)
              {
                if (i%100 == 0)
                {
                  Console.WriteLine("Deleted {0} groups.", i);
                }
                i++;
                web.SiteGroups.Remove(name);
              }
            }
          }
        }
      }
      catch (Exception e)
      {
        Console.WriteLine(e);
      }
    }
  }
}