Re: sql_trace filtering

From: Gogala, Mladen <gogala.mladen_at_gmail.com>
Date: Tue, 21 Dec 2021 10:30:36 -0500
Message-ID: <6fb22582-0639-8533-a754-552069bb846d_at_gmail.com>



_*CAUTION: This email has originated from an extremely suspect and sometimes very grumpy sender. Proceed with extreme caution and use the Force.*_

On 12/21/2021 10:14 AM, Adric Norris wrote:
> Is it possible to add a filter for user ID/name as well? I've been
> searching, but can't seem to find any examples of this if so.
>
> Thanx!

Hi Adric!

You can create on logon trigger for the specified user and use "ALTER SESSION" instead of "ALTER SYSTEM".

Regards

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 21 2021 - 16:30:36 CET

Original text of this message