Re: Not able to insert to an imported table

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Tue, 27 Aug 2013 17:48:54 +0200
Message-ID: <CAA9w=EuKyA0NjtqVRbP86x+wkuumh7vmi488iGBg4DqTDCTS6w_at_mail.gmail.com>



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
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
Received on Tue Aug 27 2013 - 17:48:54 CEST

Original text of this message