Re: error 1031 and prepared statements

Never mind, It turns out that I was not enabling the role in our connection pooling -
just in the initial connection.

Doh.

B.
bernie9696_at_my-deja.com wrote in message <8cfsjh$99p$1_at_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 - 16:33:44 CDT