Reset all Permissions in Database? RRS feed

  • Question

  • Hello everyone,

    now we have kind of a worst case scenario here. Some permissions inside the Databases have been changed and now SharePoint can't access some Databases anymore. An easy way would be to give the service account just full db-owner rights on all databases but I think that isn't the optimal way.

    Is there a way to "reset" the permissions that are set in the Databases? This includes the Config-DB but also Content DBs and Service DBs. However, if there is no automatic way of reset, is there any Documentation on how the rights should be?


    Tuesday, November 20, 2012 11:42 AM


All replies