In getting my setup to run BlogEngine I choose to use an MSSQL database. In setting up the database I ran the create script provided with the download; however, I struggled to find clear documentation or tools for setting up the proper permissions for the database user. Below (and attached) is the permissions script necessary to setup the proper permissions. In this script I grant all the ncessary access to the WebuserRole. My database user is a member of that role.
GRANT SELECT,INSERT,UPDATE,DELETE ON [dbo].[be_Categories] TO [WebuserRole]
GO
GRANT SELECT,INSERT,UPDATE,DELETE ON [dbo].[be_Pages] TO [WebuserRole]
GO... [More]