Re: Not able to insert to an imported table

From: <david_at_databasesecurity.com>
Date: Tue, 27 Aug 2013 17:19:44 +0100
Message-ID: <EFFFF0A728BF45E285A3134030474B33_at_NAUTILUS>

So, from what I can tell, DBMS_SESSION is probably calling SET_CONTEXT. The CONTEXT in question probably doesn't exist on the new system. This is leading to the error.
Cheers,
David

-----Original Message-----
From: Lu Jiang
Sent: Tuesday, August 27, 2013 5:05 PM
To: Toon Koppelaars
Cc: list
Subject: Re: Not able to insert to an imported table

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

-- 
Toon Koppelaars
RuleGen BV
Toon.Koppelaars_at_RuleGen.com
http://www.rulegen.com/
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
--
http://www.freelists.org/webpage/oracle-l



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

Received on Tue Aug 27 2013 - 18:19:44 CEST