EXECUTE permission denied

[Former Member]

hi

Im getting the following error when querying a database :

<b>

Error when executing statement for table/stored proc. 'procedure name' (structure 'Select'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]EXECUTE permission denied on object 'procedure name ', database '<database name>', owner 'owner name'</b>

Is it because the user use to access in the comunication channel does not have rights on the given databse / table or something else as well ??

please suggest

sd

[Former Member]

Hi,

It looks like this user doesn't have permission.

Regards,

wojciech

[Former Member]

Hi,

yes right.

the user which you use in the JDBC Adapter isn't allowed to execute the stored procedure.

Regards,

Robin

[former_member206604]

Hi,

Check out for the execute permission for the user in the database.

Regards,

Prakash