Error: The EXECUTE permission was denied on the object ”, database ”, schema ”.


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′;
GO

EXECUTE sp_addrolemember @rolename = N’db_datawriter’, @membername = N’user1′;
GO

EXECUTE sp_addrolemember @rolename = N’db_datareader’, @membername = N’user1′;
GO

Like this we can enable required Role Memberships.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s