Re: Logon Trigger Alter Session cmds not doing anything 19.17 (Solved)

While this wasn't the exact solution, it pointed me to the problem.

I missed this SYNTAX:

AFTER logon ON user_redacted.schema

Whereas I had :

AFTER logon ON schema

It's AFTER logon ON <user>.schema

Thanks!

On Fri, Jun 16, 2023 at 10:06 AM Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

> Chris,
>
> I am wondering if it would make any difference
> if you were to try adding “ON PLUGGABLE DATABASE”
> after the “on schema”.
>
> Regards,
> Rajeev
>
>
>
> On Jun 16, 2023 at 8:49 AM, <Chris Taylor
> <christopherdtaylor1994_at_gmail.com>> wrote:
>
> I'm a bit puzzled by this one. I'm trying to limit parallel
> processes/slaves for one particular user and I've created a logon trigger
> that does this:
>
> CODE:
> ---------
> CREATE or replace TRIGGER user_redacted.logon_trigger
> AFTER logon ON schema
> enable
> BEGIN
> execute immediate 'alter session set parallel_threads_per_cpu=1';
> execute immediate 'alter session set
> parallel_degree_policy=''ADAPTIVE''';
> execute immediate 'alter session set parallel_degree_limit=4';
> END;
> /
>
> I logon to that schema (in a PDB) after creating the trigger (in the PDB)
> and none of those params take effect.
>
> I can alter those params in a session as that user with no problem, but
> the trigger isn't doing it. Even tried doing a database-wide trigger and
> checking if the user is my user of interest. Still nada.
>
> I'm clearly missing something and hoping you guys can point me to
> something obvious?
>
> The user does NOT have DBA role but does have a lot of system privileges
> like "CREATE ANY" , "DROP ANY" privs (for some reason from the past).
>
> Thanks,
>
> Chris
>
>

--
http://www.freelists.org/webpage/oracle-l