http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspxWe can accomplish this requirement by using SPQuery. This sample code I have developed for taking all the items with modified by (column name is "Editor") user BLR3R7-19C\\test1. If you are using this code in a SharePoint web context then oWeb.CurerntUseren-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8972803Thu, 02 Oct 2008 07:05:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:8972803 Programmatically retrieve the items in a list based on the current user : EasyCoded<p>PingBack from <a rel="nofollow" target="_new" href="http://www.easycoded.com/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user/">http://www.easycoded.com/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user/</a></p> http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8972957Thu, 02 Oct 2008 09:11:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:8972957Vin Diesel Pham<p>Programmatically retrieve the items in a list based on the current user : EasyCoded </p> http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8991926Wed, 08 Oct 2008 22:45:49 GMT91d46819-8472-40ad-a661-2c78acb4018c:8991926Dave<p>Is there a way you can pull a list based on the users rights? &nbsp;I dont want to pull the whole list and check each list item to see if the current user has rights. &nbsp;Im hoping there is a way to pull the filtered list.</p> http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8992343Thu, 09 Oct 2008 05:06:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:8992343sowmyancs<p>I am sorry Dave. Per my knowledge there is no a way to pull the lists based upon user rights. Let me know if you get any workaround.</p> http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8992931Thu, 09 Oct 2008 18:22:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:8992931Dave<p>Ok I found a way to do it using impersonation. &nbsp;Check out this article <a rel="nofollow" target="_new" href="http://www.sharepointblogs.com/tanujashares/archive/2007/08/07/impersonation-in-sharepoint-2007.aspx">http://www.sharepointblogs.com/tanujashares/archive/2007/08/07/impersonation-in-sharepoint-2007.aspx</a></p> http://blogs.msdn.com/sowmyancs/archive/2008/10/02/programmatically-retrieve-the-items-in-a-list-based-on-the-current-user.aspx#8993104Thu, 09 Oct 2008 21:07:13 GMT91d46819-8472-40ad-a661-2c78acb4018c:8993104sowmyancs<p>Fantastic. Yes using that method we can retrieve the lists. Thanks Dave !</p>