Error: The EXECUTE permission was denied on the object ”, database ”, schema ”.
Description: Database’s requires specific roles or privileges, so that the users can perform or run stored procedures, functions, views etc without any issues. One of that is the EXECUTE permission, which requires specific permissions to perform that activity properly.
Solution: Go to Object Explorer, open Security followed by User node, then right click and select properties of the configured user login. Under General tab, enable db_datareader, db_datawriter and db_owner role memberships.
Or another way is as follow.
EXECUTE sp_addrolemember @rolename = N’db_owner’, @membername = N’user1′;
EXECUTE sp_addrolemember @rolename = N’db_datawriter’, @membername = N’user1′;
EXECUTE sp_addrolemember @rolename = N’db_datareader’, @membername = N’user1′;
Like this we can enable required Role Memberships.