none
My site users are unable to edit their profile

    Question

  • We migrated from SP 2010 to SP 2013, and we notice users are unable to edit their profile in SP 2013. Does the web app pool account running my sites or user profile sync account need specific access to the databases to allow them to edit their profile?

    Logs:

    SqlError: 'The EXECUTE permission was denied on the object 'proc_MSS_GetSchemaHighLevelInfo', database 'Search', schema 'dbo'.'

    • Edited by Bob2308 Friday, March 17, 2017 2:35 PM
    Friday, March 17, 2017 12:58 PM

All replies

  • Hi Bob,

    Please go to User Profile Service Application in Central Administration > Manage user permissions > check if users have permission to edit user profiles.

    And the error message is for search database, not for user profile databases.

    Best Regards,

    Victoria

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

    Monday, March 20, 2017 12:50 PM
    Moderator
  • Hi Bob,

    I am checking to see how things are going there on this issue. Please let us know if you would like further assistance.

    Best Regards,

    Victoria


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

    Friday, March 31, 2017 3:41 AM
    Moderator