none
Reset all Permissions in Database?

    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?

    Thanks!!
    Regards
    Chris

    Tuesday, November 20, 2012 11:42 AM

Answers

All replies