plz help to solve this error

[cfnew]

hi when i tried to call stored proc in coldfusion i am gettting this error :

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The EXECUTE permission was denied on the object 'getData', database 'cao', schema 'dbo'.

can any one help me how to solve this type of error

[Dan_Bracuk]

Talk to your dba or whatever you call the person who controls the permissions on your db.

[ilssac]

The user you are using to connect to the database does not have permission to run an "ECECUTE" command on the objects in the code.

Add permissions to the user or rework the code to work within the limits of the permissions defined by the user.

[Michael Borbor]

You have to enable the permissions to execute store prod at Sql Server

for your login account.

Sincerely,

Michael

El 14/05/2009, a las 8:52, kirannaga <forums@adobe.com> escribió:

>

hi when i tried to call stored proc in coldfusion i am gettting this

error :

>

Error Executing Database Query.

[SQLServer JDBC Driver][SQLServer]The EXECUTE permission

was denied on the object 'getData', database 'cao', schema 'dbo'.

>

>

>

can any one help me how to solve this type of error

>