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.
