[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

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
0
snazaire
Asked:
snazaire
  • 3
  • 2
2 Solutions
 
Justin SmithSr. 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
 
snazaireAuthor 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
 
snazaireAuthor Commented:
I am using MOSS 2007...
0
 
snazaireAuthor Commented:
I've requested that this question be deleted for the following reason:

No answer has been provided for over a few days...
0
 
Justin SmithSr. 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now