Event 5214 – Execute permission was denied on object

The following event was occuring on our environment quite often:

Event Type: Error

Event Source: Windows SharePoint Services 3 Event Category: Database Event ID: 5214 Date: 4/7/2013 Time: 1:19:39 PM User: N/A Computer: [SERVER] Description: Insufficient SQL database permissions for user ‘[account]’ in database ‘[database]’ on SQL Server instance ‘[SQL SERVER]’. Additional error information from SQL Server is included below.

The EXECUTE permission was denied on the object ‘proc_FetchDocForUpdate, database ‘[database]’, schema ‘dbo’.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

To solve this issue, perform the following steps:

  1. Open the SQL Management Studio
  2. Browse to the database in question, in our case “‘SharePoint_Admin_DB”
  3. Open the database and then Security > Roles > Database Roles
  4. In the right part of the window, right click the WSS_Content_Application_Pools role and click Properties
  5. Select the menu option “Securables”
  6. Click “Add”
  7. Select “Specific objects” and click “OK”
  8. Click “Object Types”, select “Stored Procedures” and click “OK”
  9. Add the following stored procedures: proc_FetchDocForUpdate, proc_GetWebMetaInfo, proc_UpdateDirtyDocument, proc_UpdateListItem
  10. Click “OK” to add these stored procedures
  11. Select the added stored procedures and select “Execute” in the “Grant” column.
  12. Click “Add” once more
  13. Select “Specific objects” and click “OK”
  14. Click “Object Types”, select “Views” and click “OK”
  15. Add the following view: UserData
  16. Click “OK” to add this view
  17. Select the added view and select “Select” in the “Grant” column.
  18. Click “OK” to complete

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">