Re: Strange ORA-01031 Error

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 06 Nov 2012 15:03:49 +0000
Message-ID: <509926D5.1030901_at_dunbar-it.co.uk>



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 11.2.0.3 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.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

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

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 06 2012 - 16:03:49 CET

Original text of this message