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 -- //www.freelists.org/webpage/oracle-l