Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: error 1031 and prepared statements

Re: error 1031 and prepared statements

From: Bernie Wieser <bernhard_at_cgy.valmet.com>
Date: Wed, 05 Apr 2000 21:33:44 GMT
Message-ID: <YiOG4.485$sR2.13826@read2.inet.fi>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US