Re: ALTER SESSION SET QUERY_REWRITE_INTEGRITY = TRUSTED
From: Sanae <aithssaine.sanae_at_gmail.com>
Date: Thu, 16 Jul 2015 05:48:18 -0700 (PDT)
Message-ID: <e9a2a30f-defd-4130-824b-fc4e037ad6ab_at_googlegroups.com>
I tested this code for a regular user ('XXX') connection and also as sysdba. My user 'XXX' has all privileges .
i don't understand why the trigger fails to execute this query! however it work's manually
Date: Thu, 16 Jul 2015 05:48:18 -0700 (PDT)
Message-ID: <e9a2a30f-defd-4130-824b-fc4e037ad6ab_at_googlegroups.com>
I tested this code for a regular user ('XXX') connection and also as sysdba. My user 'XXX' has all privileges .
i don't understand why the trigger fails to execute this query! however it work's manually
SQL> ALTER SESSION SET QUERY_REWRITE_INTEGRITY = TRUSTED; Session modifiÚe.
SQL> Received on Thu Jul 16 2015 - 14:48:18 CEST