Re: ALTER SESSION SET QUERY_REWRITE_INTEGRITY = TRUSTED
From: Mark D Powell <markp28665_at_gmail.com>
Date: Thu, 16 Jul 2015 07:36:46 -0700 (PDT)
Message-ID: <22324593-1b67-4d45-8fa6-9ba58bbc70fa_at_googlegroups.com>
On Thursday, July 16, 2015 at 8:48:23 AM UTC-4, Sanae wrote:
> 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>
Database event triggers do not fire for users with a specific system privilege which sysdba connections have being that the connections are user SYS. What system privileges does the target user have?
Date: Thu, 16 Jul 2015 07:36:46 -0700 (PDT)
Message-ID: <22324593-1b67-4d45-8fa6-9ba58bbc70fa_at_googlegroups.com>
On Thursday, July 16, 2015 at 8:48:23 AM UTC-4, Sanae wrote:
> 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>
Database event triggers do not fire for users with a specific system privilege which sysdba connections have being that the connections are user SYS. What system privileges does the target user have?
HTH -- Mark D Powell -- Received on Thu Jul 16 2015 - 16:36:46 CEST