title: EXECUTE permission denied on object, database , owner 'dbo'
body: <p>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.</p>
  
  <pre><code>    [Macromedia][SQLServer JDBC Driver][SQLServer]EXECUTE permission denied on object 'GetPSRreportStock', database 'CGTSP_GET',
  
    &lt;cfstoredproc procedure="FP_Get..GetStartStopTotalBalesCott" datasource="#TS#" username="#UNT#" password="#SPW#"&gt;
  
        &lt;cfprocparam  type="in" cfsqltype="CF_SQL_INTEGER" dbvarname="@reportYear"  value="#xxMDB#"&gt;
          &lt;cfprocparam  type="in" cfsqltype="CF_SQL_INTEGER" dbvarname="@orderMonth"     value="#xxOBDB#"&gt;
          **&lt;cfprocresult name="ccDPR"&gt;**
      &lt;/cfstoredproc&gt;
  </code></pre>
  
  <p>The CF code is in MX-6.
  How to correct the error?</p>