Duplicate accounts in SharePoint causing permission loss?

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.


Stan
snazaireSharePoint AdminAsked:
Who is Participating?
 
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
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.
0
 
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
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?
0
 
snazaireSharePoint AdminAuthor Commented:
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?
0
 
snazaireSharePoint AdminAuthor Commented:
I am using MOSS 2007...
0
 
snazaireSharePoint AdminAuthor Commented:
I've requested that this question be deleted for the following reason:

No answer has been provided for over a few days...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.