EXECUTE permission denied on object, database , owner 'dbo'

Question

I successfully executed a stored procedure on a SQL2005.When I wanted to populate the results in a form via CFSTOREDPROC , I am getting the following error. ``` [Macromedia][SQLServer JDBC Driver][SQLServer]EXECUTE permission denied on object 'GetPSRreportStock', database 'CGTSP_GET', **** ``` The CF code is in MX-6. How to correct the error?

Accepted Answer

Check to make sure the user trying to run the stored proc has execute permissions, you can do this in SQL Server Management Studio by going to the Database -> Programmability -> and Right Click on the Stored Proc and select 'Properites', then go to the 'Permissions' section and see if your user is there, if its not, you can add the user and give it EXECUTE permissions, or you can do the following in a new query: ``` GRANT EXECUTE TO ON ```

EXECUTE permission denied on object, database , owner 'dbo'

Solution

Problem