What are you calling dbms_session to DO - that what you need the privilege for, not on dbms_session itself. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority Information Systems 1240 W. 6th Street Cleveland, Ohio 44113 >>> Lu Jiang <lu.jiang69@xxxxxxxxx> 8/27/13 12:05 PM >>> granted execute on dbms_session to the user did not help, even granted dba role did not help. Thanks, Lu ________________________________ From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx> To: lu.jiang69@xxxxxxxxx Cc: list <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, August 27, 2013 11:48 AM Subject: Re: Not able to insert to an imported table 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 >-- >https://access.seg.att.com/redir/?2ztdxdZZMSzteZPhOehdw0Do_VYGjFM0701bqh_aNSN_BPPt-hpuoshvpuvdTdRzJz_bDBO5mUmY5eN_PVkDjw09IsYNsSyOe7e8CzBNxwSMOr1vF6y06lCq8d87-q89Rd44Ek-cPh1eFEwS1EwAGJmc_gd44Z87-rDUvf5zZB0SyrodETjLsQsIICUF7t > > > > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx https://access.seg.att.com/redir/?ETjojvvsdETjLsQszAjo0abp_AvxO-6XYyOYMUy-OY-rKrH7r7-nfbAaJMJUatz_DOFeD00joVVyVJ5Aseshd7bz31JxAS2_id40cHcQgqgfYQgjGq89gFYpCy2tjh1I3h19lqIp-wq89WgfYTfM-ub7Xa1JcSMrhKDuVEVppdMT1qtSJs TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" https://access.seg.att.com/redir/?ETjojvvsdETjLsQszAjpjEJD-h-7bVGH22NsxJyJGCvynDUvcTvAmnC74nSnDPtPtoXo_OVVsxlK5L1jIvY-l9QU02r7fcndEIzxPy9EVsoodIcCMnWhEw1BpCy3i1_Cy2tjh1a5fzcQgjGq8dwq89aHlzfQ3h1fi1_CV-7PNo_pgdICS3qdQXTd7bb9IEobIb4o6SyV -- https://access.seg.att.com/redir/?ETjojvvsdETjLsQszAjo09Sf-vaAWs01M0iSAvOItIvVsYTvAmnC74nSnDPtPtoXo_OVVsxlK5L1jIvY-l9QU02r7fcndEIzxPy9EVsoodIcCMnWhEw1BpCy3i1_Cy2tjh1a5fzcQgjGq8dwq89aHlzfQ3h1fi1_CV-7PNo_pgdI6S3qdQXTd7bb9ItT_Yx0k . -- //www.freelists.org/webpage/oracle-l