Duplicate accounts in SharePoint causing permission loss?

Posted on 2012-09-12
Last Modified: 2012-12-17
Hi fellow EEs,
I am seem to be running into this issue where out of nowhere we get users reporting that they have lost their permissions on their site. It turns out that some these users in the DB have duplicate entries. Some are active and others not (0 or 1).
Can somebody help me solve this?  I would really appreciate it.

Question by:snazaire
    LVL 38

    Assisted Solution

    What do you mean by "active and others not"?  Are you looking in the UserInfo table in SQL?  If so, even if they had isActive=0, they could still access the site.

    What version of SHarePoint?

    Author Comment

    Thanks Ach1lles. Well I thought the isActive = 0 meant that you couldn't access the site anymore. Do you mind elaborating for me on the meanings of these codes in the UserInfo table in SQL?

    Author Comment

    I am using MOSS 2007...

    Author Comment

    I've requested that this question be deleted for the following reason:

    No answer has been provided for over a few days...
    LVL 38

    Accepted Solution

    I could have swore I had written long responses to this thread.  Please don't delete yet.

    How did you determine that there were multiple entries in the database?  It's quite normal to see the user id multiple times in the database.  You have to look at the user id and site/webid combination.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now