SQL & PL/SQL

Env. 19cSE2

We need to add privileges to a role for recently created objects (i.e. tables and views) on a daily basis.

select distinct o.owner
              , o.object_name
from sys.all_objects o
join dba_tab_privs d
on o.owner = d.owner
where o.owner in('SCHEMA1', 'SCHEMA2')
      and o.object_type in('TABLE', 'VIEW')
      and o.status = 'VALID'
      and o.object_name <> d.table_name
      and o.created between sysdate - 7 and sysdate -- better date range? Will probably have gaps
               -- and o.created = sysdate -- or better current date? With a scheduled job checking several times per day              

Thanks!