Share via

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SharePoint 2013 User Profile

  • Article

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SID: S-1-5-21-2738186777-3937669245-3595685374-1123 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'ADXWSQL.adxweb.ae'. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object 'proc_putObjectTVP', database 'SharePoint_Config', schema 'dbo'.

This is a caused by not having permission to database objects of using least privileges configuration in a farm configuration. Thus you need to give permission exclusively to this Object.

First, you need to connect to SharePoint Database using a privileged account.

Go to the SharePoint Config database and Security section. Then go to Roles and find WSS_Content_Application_Pools under the Database Roles section.

  

https://2.bp.blogspot.com/-ikTki9CMVG8/Wikn8CXyxbI/AAAAAAAASU0/51zUR9dkGs8rqzSrLYJy7Fc9oZy1Lk2sACKgBGAs/s320/3128237421723084868_1.png

Double-click (or right-click -> Properties) the item and select the Securable section in the modal window.

https://3.bp.blogspot.com/-GpSDGMTCbvI/WikoAjIMpJI/AAAAAAAASU4/bOUdl2YvM6Ag7RitUTZb0eCnM66mZkF7gCKgBGAs/s320/3128237421723084868_2.png

Click Search and select Object Type in the Window. Click OK.

https://4.bp.blogspot.com/-tC6wsdO51SU/WikoEONuxxI/AAAAAAAASU8/duAQgKLNU_4EAdqA9JoFQd5WRVKFS3k_gCKgBGAs/s320/3128237421723084868_3.png

Click Object Types and select the Stored Procedure.

https://4.bp.blogspot.com/-FQLGTZrpo_E/WikoGxsJsiI/AAAAAAAASVA/ejjxavOLbVsp0J9IB9UreHios24YfIBpwCKgBGAs/s320/3128237421723084868_4.png

 Type proc_putObjectTVP in Object names section and check names to select the item.

https://4.bp.blogspot.com/-B9wECA9hpmk/WikoJ-iurcI/AAAAAAAASVE/UpRko3mhwD0NNeRmI4wqJn76e7mwVkotACKgBGAs/s320/3128237421723084868_5.png

Select the item and click OK.

https://4.bp.blogspot.com/-1A9xtJHl-2w/WikoMuPVzmI/AAAAAAAASVI/sfL_DwhMe-0KiuyfIqaYXxEkw7OFXYqDwCKgBGAs/s1600/3128237421723084868_6.png

You can see the item in securable. Give the Execute permission to the object.

https://4.bp.blogspot.com/-GsdFCCv3F3I/WikoPdUzWjI/AAAAAAAASVM/qQ9y3Cnd3AUvyaHUwxyt2CIrwZU5UyawQCKgBGAs/s320/3128237421723084868_7.png