Re: Not able to insert to an imported table
Date: Tue, 27 Aug 2013 13:19:57 -0400
Message-Id: <521CA77D0200000B0050CEF3_at_groupwise.gcrta.org>
see: Sys.Dbms_session Insufficient Privileges Ora-01031 (Doc ID 365055.1)
>>> Lu Jiang <lu.jiang69_at_yahoo.com> 8/27/13 1:13 PM >>>
Yes David. The following are the lines pointed by the error message: BEGIN
DBMS_SESSION.SET_CONTEXT(get_context_name, 'DB_TIMEZONE', tz); END;
……
BEGIN
v_db_timezone := SYS_CONTEXT(get_context_name, 'DB_TIMEZONE'); IF (v_db_timezone IS NULL) THEN
v_db_timezone := pkg_tool.get_db_timezone; set_db_timezone(v_db_timezone);
END IF;
RETURN v_db_timezone;
END; Could you please advise on what should I do to fix this?
Thanks,
Lu
From: "david_at_databasesecurity.com" <david_at_databasesecurity.com> To: lu.jiang69_at_yahoo.com; Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Cc: list <oracle-l_at_freelists.org>
Sent: Tuesday, August 27, 2013 12:19 PM
Subject: Re: Not able to insert to an imported table
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
>--
>https://access.seg.att.com/redir/?adQS4TTT3qdQXTd78V4S02tz_DOFeD00s04JF7YH7r7-nfdTV5BVxN5ZBVYTsTmeSfYKun8lrxrMkX7_fBite00CPhOCMOrhp73D4ShOapJxAS2_id40cHcQgqgfYQgjGq89gFYpCy2tjh1I3h19lqIp-wq89WgfYTfM-ub7Xa1J4S-rhKDuVEVppdw7TTZpzY
>
>
>
-- Toon Koppelaars RuleGen BV Toon.Koppelaars_at_RuleGen.com https://access.seg.att.com/redir/?2ztdxdZZMSzteZPhOehdw0EJD-h-7bUrLObbP3ybXbPVKVKItIvVsYKgGT2TwFSf-vaAWs01dCzBdxASyOe7e9IzAkPr39I5-Aq80pmpEwQwvVEwDkQgixjUPd44WCy3o6y2iGRoPZ0QgjQwvVKvxYYmfSk3qpJYSzteZPhOOOrhsHVxCVm TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyrat5I_OfMVvdlogmbAdIlJkPYiY_3VCXYyOYMUy-OY-rKrH7r7-nfbAaJMJUatz_DOFeD00jpEVjopdEIzxPyr8V5cSMOr1vF6y06lCq8d87-q89Rd44Ek-cPh1eFEwS1EwAGJmc_gd44Z87-rDUvf5zZB0SOrvdETjLsQsIICOG0b -- https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyr01eN_PVkDjw0e02mQz-lzJz_bDCXYyOYMUy-OY-rKrH7r7-nfbAaJMJUatz_DOFeD00jpEVjopdEIzxPyr8V5cSMOr1vF6y06lCq8d87-q89Rd44Ek-cPh1eFEwS1EwAGJmc_gd44Z87-rDUvf5zZB0SMrvdETjLsQsIIC_evzKDzy -- https://access.seg.att.com/redir/?adQS4TTT3qdQXTd78V4S02tz_DOFeD00s04JF7YH7r7-nfdTV5BVxN5ZBVYTsTmeSfYKun8lrxrMkX7_fBite00CPhOCMOrhp73D4ShOapJxAS2_id40cHcQgqgfYQgjGq89gFYpCy2tjh1I3h19lqIp-wq89WgfYTfM-ub7Xa1JYS-rhKDuVEVppdZcrpSAFO .-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 27 2013 - 19:19:57 CEST