Thursday, November 20, 2014

The permissions in SP_DATA_ACCESS role by default.

The permissions in SP_DATA_ACCESS role by default.

The SP_DATA_ACCESS role replaces the db_owner role in SharePoint 2013.

The SP_DATA_ACCESS role is the default role for database access and should be used for all object model level access to databases.

1.   Grant EXECUTE or SELECT on all SharePoint stored procedures and functions

2.   Grant SELECT on all SharePoint tables

3.   Grant EXECUTE on User-defined type where schema is dbo

4.   Grant INSERT on AllUserDataJunctions table

5.   Grant UPDATE on Sites view

6.   Grant UPDATE on UserData view

7.   Grant UPDATE on AllUserData table

8.   Grant INSERT and DELETE on NameValuePair tables

9.   Grant create table permission 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.