join dba_sys_privs, dba_roles, dba_tab_privs - for each user create roles

oracle 19.15 or Oracle Linux

I am trying to write a query to get all system privs, roles and all table privs(group by each table in one line , select, insert,update,delete) granted to roles but not successful.

any and all helps are appreciated.