Looks like you are missing a direct (ie. not via role) execute privilige on dbms_session... On Tue, Aug 27, 2013 at 5:39 PM, Lu Jiang <lu.jiang69@xxxxxxxxx> wrote: > Hi all, > I am getting a strange issue. After impdp the schema of user plateau to a > target database, plateau user is not able to insert data to one of the > table owned by itself and getting the following error: > ORA-01031: insufficient privileges > ORA-06512: at "SYS.DBMS_SESSION", line 101 > ORA-06512: at "PLATEAU.PKG_STATE", line 56 > ORA-06512: at "PLATEAU.PKG_STATE", line 68 > ORA-06512: at "PLATEAU.PKG_QUALIFICATION", line 834 > ORA-06512: at "PLATEAU.PT_AI_QUAL_CPNT", line 2 > ORA-04088: error during execution of trigger 'PLATEAU.PT_AI_QUAL_CPNT' > > Plateau user has been granted exact same privileges (system, role and > objects) as in the source database. Insert to this table works fine in the > source database but failed in the impdp target database.When disable the > trigger in the error message above, Insert can be completed in the target > db. The packages in the error message above are called by the trigger. > Have done some research but could not find related info. Try to submit SR > however Oracle support web site is down. Could anybody shed some light on > this? > The databases are 11g.Thanks, > Lu > -- > //www.freelists.org/webpage/oracle-l > > > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text -- //www.freelists.org/webpage/oracle-l