Re: Strange ORA-01031 Error

From: Norman Dunbar <>
Date: Tue, 06 Nov 2012 15:03:49 +0000
Message-ID: <>

On 06/11/12 14:20, Michael Dinh wrote:
> Hello,
> I have been experiencing ORA-01031 insufficient privileges from application
> using Weblogic (WLS) connected as the schema owner.
Is the application executing some PL/SQL code with objects in other schemas AND has permissions to those objects through a role as opposed to directly?

> Database is the SQL itself does not fail when execute from
> SQL*Plus and only fails when execute from the application using WLS.
Can you show us the SQL or PL/SQL that is failing?

> Restarting the database resolved the issue one time but it's reoccurring.
Hmmm, that probably discounts the role privs in PL/SQL then, if a restart solved it.


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Tue Nov 06 2012 - 16:03:49 CET

Original text of this message