Automatic maintenance of privileges

BrunoVroman

User_L033I

Hi Bruno, Thanks for sharing this document. Since DBMS_JOBS is no longer used in 19c and instead need to use: DBMS_SCHEDULER, I am trying to figure out, how to replace DBMS_SCHEDULER into the trigger.

  DBMS_SCHEDULER.CREATE_JOB(job_name => 'j', job_type => 'PLSQL_BLOCK', job_action => 'p1');

But, this is not working. Any help is greatly appreciated.

EdStevens-OC

UserL0331,

You just responded to a message that is over 10 years old. I remember Bruno, but haven't seen him in quite a while.

 this is not working

And that is devoid of actionable information. Please start at the beginning and tell exactly what you've done and excactly what is happening vs. what you expect to happen. Best if you just open your own thread for it.