none
db_owner on content databases farm account

    Question

  • We are running SharePoint 2013 enterprise and SQL 2012. I have noticed that the farm account doesn't have db_owner access on all of the content databases. After reading technet the farm account should have db_owner rights on all content databases correct? Just want to make sure since something is causing the farm account to loose db_owner permissions. Thanks, ozsp


    Thursday, March 16, 2017 4:30 PM

All replies

  • Hi ozsp,

    Members of the db_owner fixed database role can perform all configuration and maintenance activities for all databases in the server farm, and can also drop the database in SQL Server.

    If the farm account does have db_owner fixed database role, he cannot perform these options.

    Best regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Saturday, March 18, 2017 7:41 AM
    Moderator