Re: Not able to insert to an imported table

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 27 Aug 2013 12:14:16 -0400
Message-Id: <521C98180200000B0050CED7_at_groupwise.gcrta.org>

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_at_yahoo.com> 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_at_rulegen.com> To: lu.jiang69_at_yahoo.com
Cc: list <oracle-l_at_freelists.org>
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_at_yahoo.com> 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_at_RuleGen.com 
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 






.
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 27 2013 - 18:14:16 CEST