Re: Logon Trigger Alter Session cmds not doing anything 19.17

  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 (mailto: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