Re: ora-01031:insufficient privileges.

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 22 Jul 2005 01:54:31 GMT
Message-ID: <Xns969AC05A84D5DSunnySD@68.6.19.6>

li.js_at_neusoft.com (Jinshan Li) wrote in news:b60ce575.0507211652.424991f7_at_posting.google.com:

> I defined a cursor for selecting V$LOGMNR_CONTENTS.
> And do the following action:
> fetch cur BULK COLLECT
> into collect1,collect2,....
> limit 5000
>
> When it is run in oracle9i, it is ok.
> But,it is run in oracle 10g,there is a error:
> ora-01031:insufficient privileges.
>
> I check the user's privileges, it is same in 10g as 9i.
>

If the privileges were REALLY 100% the same, then no error would result.

Believe the error message is accurate & find the difference. Received on Thu Jul 21 2005 - 20:54:31 CDT