How to resolve error message "EXECUTE permission was denied on the object 'usp_GetSelectData', database 'ARCOSDB', schema 'dbo'."

How to resolve error message "EXECUTE permission was denied on the object 'usp_GetSelectData', database 'ARCOSDB', schema 'dbo'."


How to resolve error "EXECUTE permission was denied on the object 'usp_GetSelectData', database 'ARCOSDB', schema 'dbo'.while hosting ACMO page.



Resolution:

In SQL Server Management Studio, go to security->schema->dbo.



Double-click dbo, select the Permissions page, then click the "View database permissions" link in blue:

enter image description here

Select the user for whom you want to change permissions, and look for the "Execute" permission under the "explicit" tab:

enter image description here

Choose the appropriate permission by checking the appropriate box.


Restart the SQL Service once.