error 1031 and prepared statements

From: <bernie9696_at_my-deja.com>
Date: Wed, 05 Apr 2000 17:20:05 GMT
Message-ID: <8cfsjh$99p$1@nnrp1.deja.com>

Hiya. I am writing an application that grants privileges through roles.

If I have a statement "delete from table.x where id = 3", the SQL works.

However, it seems if I use a prepared statement, I get an insufficient privileges error.

I have granted, from what I can see, all privileges to the roles required to do the delete. I have granted access on the tables to the roles.

Any suggestions appreciated???

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 12:20:05 CDT