SPList.GetItems(query) does not return SPListItems where the permissions are not inherited

Question

I'm using the following code:

protected void TraverseFolder(SPList list, SPFolder folder)
{
    SPQuery qry = new SPQuery() { Folder = folder };
    SPListItemCollection listFolderItems = list.GetItems(qry);
    foreach (SPListItem item in listFolderItems)
    {
        // Do stuff.
    }
}

If the items in the list inherit their permissions from the parent folder then they appear in the collection, if I break inheritance, but keep the same permissions, they don't appear. What's going on?

Stuart.

UPDATE: If I ensure that the user has View Only permissions on another folder (at the same level as the files they can't see) then the files are returned in GetItems. If I take that permission away they don't get returned.

Answer 1

Upgraded the SharePoint version to Service Pack 2 (12.0.0.6421) and this resolved the issue.

Answer 2

Verify that the permissions really do match up. If you're running in a web part, output SPContext.Current.Web.CurrentUser.LoginName. Double-check this username against the permissions for the list, folder, and list items you are expecting to see.

Alternatively run the code with elevated privileges and see if it works.

Answer 3

i have the same issue, mi LAB:

I had a splist and some spqueries... it was working fine... my queries are not runing under elevated priviledges... i need the context user for this operation..

Then i broke permissions for this SPlist and the query results "zero" items... the context user can see his items, and other items in other lists with the same "broken permissions situation"...

Something to do ??
thx