select table_name , max(substr(sys_connect_by_path(grantee,','),4)) grantee from (select table_name ,grantee ,cn,row_number() over(partition by table_name order by table_name) rn from (select a.table_name,a.grantee ,count(*) cn from dba_tab_privs a where a.grantee like '%DML%'group by a.table_name,a.grantee order by a.table_name ) )tstart with rn=1connect by rn=prior rn+1 and table_name=prior table_namegroup by table_name;